Method for combining database optimization and program optimization

A database and tuning technology, applied in the database field, can solve problems such as performance impact, reduce operational requirements, shorten access time, and promote tuning.

Active Publication Date: 2019-06-11
THE FIRST RES INST OF MIN OF PUBLIC SECURITY
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If you check the database every time you use this user information, it will have a relatively large impact on performance

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
  • Method for combining database optimization and program optimization
  • Method for combining database optimization and program optimization
  • Method for combining database optimization and program optimization

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038] The present invention will be further described below in conjunction with the accompanying drawings. It should be noted that this embodiment is based on the technical solution, and provides detailed implementation and specific operation process, but the protection scope of the present invention is not limited to the present invention. Example.

[0039] This embodiment provides a method combining database tuning and program tuning, such as figure 1 shown, including the following steps:

[0040] S1. Access the application system server;

[0041] S2, call the SQL statement;

[0042] S3. The application system server reads the SQL statement;

[0043] S4. The application system server invokes the SQL optimizer to optimize the SQL statement;

[0044] S5. The application system server performs program optimization;

[0045] S6. Re-execute the optimized application system;

[0046] like figure 2 Shown, wherein the specific process of step S4 is:

[0047] S4.1. An SQL r...

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 discloses a method for combining database optimization and program optimization. The method comprises the following steps: S1, accessing an application system server; S2, calling an SQLstatement; S3, reading the SQL statement by the application system server; S4, the application system server calls an SQL optimizer to optimize SQL statements; S5, the application system server performs program optimization; And S6, re-executing the optimized application system. According to the method, the database optimization process and the program optimization process are organically fused together, so that the optimization of the system performance is promoted.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for combining database tuning and program tuning. Background technique [0002] Many common systems on the market now have one or more database requests attached to one page, such as catalog pages, tree node pages, query condition pages, reports, and so on. Accessing such pages is often accompanied by database requests. When the same page is refreshed multiple times, the corresponding database requests will also use the same SQL to query the database multiple times. At this time, all queries are sent to the database, which will aggravate the congestion and cause unnecessary burden on the database. [0003] For the same data query, such as the personal information of the currently logged-in user, it may be required in multiple places in one request. For example, in the controller, permission judgment needs to be made according to the user role, user information needs t...

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/21G06F16/242
Inventor 徐常星范殿梁邢更力胡志昂刁逢博肖婷婷
Owner THE FIRST RES INST OF MIN OF PUBLIC SECURITY
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