Optimized web paging query method and device

A paging query and paging display technology, applied in the computer field, can solve the problems of no cache processing mechanism and high consumption of the total number of records calculated, so as to reduce the number of times and improve the response speed.

Inactive Publication Date: 2013-12-04
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF2 Cites 28 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The inventors of the present invention found in implementing the above scheme that there is no cache processing mechanism in the paging query algorithm, and the total number of records matching the query condition must be calculated for each query, and the consumption of calculating the total number of records is greater than the specific acquisition of the specified page range internal data overhead

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
  • Optimized web paging query method and device
  • Optimized web paging query method and device
  • Optimized web paging query method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0035] The embodiment of the present invention provides an optimized web paging query method and device, which improves the response speed of web paging query by asynchronously calculating the page range and the total number of records. The technical solution of the present invention will be introduced in detail below.

[0036] In the embodiment of the present invention, by separating and asynchronously calculating the page range and the total number of records, 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 discloses an optimized web paging query method and device. The optimized web paging query method includes asynchronously calculating a page range and a total record number: after a paging query request for an appointed page is received, firstly calculating the page range and then acquiring data loading display within the page range; and after a request for calculating the total record number is received, detecting whether a matched total record number is saved in a cache or not, if not, calculating the total record number and updating the same in the cache, and if so, reading the total record number from the cache directly. Through asynchronous calculation, the responding speed of web paging query is increased; by means of saving the total record number via the cache, the number of times for accessing to a database during web paging query is decreased, and loading efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to an optimized web paging query method and device. Background technique [0002] The Web is a typical distributed application structure, and each information exchange involves the client and the server. For users, they are facing the web client. The main task of the web client is to display information content. In web applications, due to the limitations of network transmission and front-end browser display performance, paged query is usually used, that is, the query results are displayed in a paged manner, and then the user switches the specified page range to access other pages. The data. [0003] The data query based on the web application in the prior art adopts a page-by-page query algorithm, and only obtains the data of a given page range for each interaction, so as to improve the response speed. Among them, the main processing process of the paging query algorithm is as ...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 张永军
Owner KINGDEE SOFTWARE(CHINA) 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