Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Multi-condition paging query optimization method and system, terminal and storage medium

A paging query optimization and multi-condition technology, applied in the field of data query, can solve problems affecting user experience, etc., and achieve the effect of reliable design principle, improved data query efficiency, and wide application prospects

Inactive Publication Date: 2021-01-15
SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] During the query process, the query speed will increase exponentially with the amount of table data and the number of sub-tables, which seriously affects the user experience

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
  • Multi-condition paging query optimization method and system, terminal and storage medium
  • Multi-condition paging query optimization method and system, terminal and storage medium
  • Multi-condition paging query optimization method and system, terminal and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to enable those skilled in the art to better understand the technical solutions in the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described The embodiments are only some of the embodiments of the present invention, not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0055] figure 1 is a schematic flowchart of a method in one embodiment of the present invention. in, figure 1 The execution subject may be a multi-condition paging query optimization system.

[0056] Such as figure 1 As shown, the method 100 includes:

[0057] Step 110, obtaining related tables according to query conditions and cou...

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 multi-condition paging query optimization method and system, a terminal and a storage medium. The multi-condition paging query optimization method comprises the steps of acquiring related tables according to query conditions, and counting the number of related data of the related tables; acquiring the sequence of each correlation table and the data quantity of each page atthe front end; calculating the number of target data according to the number of target query pages at the front end and the number of data of each page; and determining the correlation table to whichthe target query page number belongs according to the target data number, the data number of each page, the correlation data number of each correlation table and the sequence. Full-table scanning isavoided, a temporary table does not need to be generated in an associated mode, and the data query efficiency is improved.

Description

technical field [0001] The present invention relates to the technical field of data query, in particular to a multi-condition paging query optimization method, system, terminal and storage medium. Background technique [0002] With the development of time and the maturity of software, in the current physical infrastructure management, the amount of data is also increasing. The software will involve a large number of queries, among which multi-condition multi-table paging query is the most important display method of software management data. However, the common query method will waste a lot of time when querying multiple tables, making the query slow. The associated query keywords used include: LEFT JOIN; RIGHT JOIN; INNER JOIN; UNION. [0003] MYSQL's multi-table associated paging query is the following steps: scan the qualified data in each sub-table. Combine the matched data in the previous step to form a temporary virtual table through association. Return specific da...

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
IPC IPC(8): G06F16/2455G06F16/2453
CPCG06F16/2453G06F16/24553
Inventor 李普新
Owner SUZHOU LANGCHAO INTELLIGENT TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com