Data paging query method and device, electronic equipment and storage medium

A paging query and data technology, applied in the computer field, can solve problems such as poor query performance, and achieve the effects of improving efficiency, improving query performance, and reducing query scope

Pending Publication Date: 2021-02-26
BEIJING VRV SOFTWARE CO LTD
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0011] The invention provides a data paging query method, device, electronic equipment and storage medium, which are used to solve the defect of poor query performance in the prior art and realize high-performance paging query

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
  • Data paging query method and device, electronic equipment and storage medium
  • Data paging query method and device, electronic equipment and storage medium
  • Data paging query method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] In order to make the purpose, technical solutions and advantages of the present invention clearer, the technical solutions in the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the present invention. Obviously, the described embodiments are part of the embodiments of the present invention , but not all examples. 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.

[0044] In the description of the embodiments of the present invention, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer " and other indicated orientations or positional relationships are based on the orientations or positional relationships shown in the drawings, and are only for the convenience of describing the embodime...

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

The invention provides a data paging query method and device, electronic equipment and a storage medium, and the method comprises the steps: obtaining an additional condition corresponding to a next page according to a query result of a current page; and sending the page turning instruction and the additional condition corresponding to the next page to a server, so that the server responds to thepage turning instruction, generates a query statement for obtaining a query result of the next page according to the query condition, the paging parameter and the additional condition corresponding tothe next page, and executes the query statement to obtain the query result of the next page. According to the data paging query method and device, the electronic equipment and the storage medium provided by the embodiment of the invention, the additional condition corresponding to the next page is obtained according to the query result of the current page and is sent to the server, so that the server generates the query statement according to the query condition, the paging parameter and the additional condition corresponding to the next page and executes the query statement; and the query result of the next page is obtained, so that the query performance of continuous page turning under the condition of massive data stock can be improved.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a data paging query method, device, electronic equipment and storage medium. Background technique [0002] Data pagination means that in the case of a large amount of data, according to the number of pages specified by the user, the data content to be displayed is queried through calculations, and only part of the data is queried each time and displayed on a page-by-page basis. [0003] For databases (such as MySQL) that use middleware such as MyCat, perform pagination query and sort the returned data by time. In the prior art, query is carried out through the paging query page statement that carries the query condition, and the paging query page statement will be distributed to the database. Execute on each shard. [0004] For example, the paged query page statement is [0005] select*from operate_log where create_time between $startTime and $endTime and operate_type=$operat...

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): G06F16/242G06F16/248G06F16/28
CPCG06F16/2433G06F16/248G06F16/287
Inventor 杨泳党艳平侯泽红
Owner BEIJING VRV SOFTWARE 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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap