Paging implementation method and paging system

An implementation method and paging system technology, applied in the computer field, can solve problems such as slow query speed and unsuitable for large-scale concurrent access

Active Publication Date: 2019-08-30
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF10 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When the amount of data is large and the number of pages is large, the query speed of jumping to pages with larger page numbers is relatively slow, which is not suitable for large-scale concurrent access

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Paging implementation method and paging system
  • Paging implementation method and paging system
  • Paging implementation method and paging system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The present invention is described below based on examples, but the present invention is not limited to these examples. In the following detailed description of the invention, some specific details are set forth in detail. The present invention can be fully understood by those skilled in the art without the description of these detailed parts. In order to avoid obscuring the essence of the present invention, well-known methods, procedures, and flow charts are not described in detail. Additionally, the drawings are not necessarily drawn to scale. It should also be noted that in this article, relative terms such as first and second etc. are only used to distinguish one entity or step from another entity or step, and do not necessarily require or imply that these entities or steps Any such actual relationship or order exists between.

[0032] figure 1 It is a flowchart of a paging implementation method according to an embodiment of the present invention. figure 1 The ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

An embodiment of the invention provides a paging realization method. The method comprises the steps of receiving paging request information, wherein paging request data comprises a query SQL and check information of second data; judging whether a first cache stores the query SQL or not; retrieving the first cache according to the query SQL to obtain a first fragmentation index; judging whether a second cache stores the second data or not according to the check information; obtaining first data from the second cache; and obtaining the second data according to the first data, wherein the first fragmentation index includes at least one fragmentation index, the first cache stores a corresponding relationship between the query SQL and the first fragmentation index, the second cache stores the first data, and the first data is marked with one fragmentation index. Through combined use of the first cache and the second cache, the shortcomings of database paging and memory paging are overcome, the memory usage efficiency is improved, and a high-concurrent paging request is satisfied.

Description

technical field [0001] The invention relates to the field of computers, in particular to a paging implementation method and a paging system. Background technique [0002] With the rapid development of the Internet, the amount of information is increasing, and the data stored in some database tables has reached more than tens of millions. Facing such a huge data record set, it is impossible to display it on a single page within a limited page. Then there needs to be a way to provide fast and accurate paging display. [0003] Traditional paging techniques include two types: [0004] One is to paginate after all the data is loaded. This kind of paging usually uses the front-end paging control to perform paging, query all the data in the background and save it in the corresponding collection, and then transfer this data collection to the front-end paging control. This method is relatively simple to implement. The advantage is that the speed is fast, but the disadvantage is th...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/2453G06F16/22
Inventor 王瑞波
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products