Supercharge Your Innovation With Domain-Expert AI Agents!

Database performance optimization method

An optimization method and database technology, applied in file metadata retrieval, special data processing applications, file access structure, etc., can solve the problems of excessive face image capture performance, reduced performance, stability, limited memory resources, etc. Achieve the effect of avoiding long-time writing transactions, reducing the probability of damage, and reducing repair costs

Pending Publication Date: 2020-05-05
TIANJIN TIANDY DIGITAL TECH
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Host devices are mostly implemented with embedded solutions, with limited resources such as cpu and memory, and the performance and stability of disks will decrease under long-term use. Under such conditions, the devices cannot meet the storage requirements of such a large amount of data.
Similarly, equipment such as face NVR and face server also have performance problems caused by excessive capture of face pictures, which affects user usability

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
  • Database performance optimization method
  • Database performance optimization method
  • Database performance optimization method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] It should be noted that, in the case of no conflict, the embodiments of the present invention and the features in the embodiments can be combined with each other.

[0043] In describing the present invention, it should be understood that the terms "center", "longitudinal", "transverse", "upper", "lower", "front", "rear", "left", "right", The orientations or positional relationships indicated by "vertical", "horizontal", "top", "bottom", "inner", "outer", etc. are based on the orientation or positional relationships shown in the drawings, and are only for the convenience of describing the present invention Creation and simplification of description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operate in a specific orientation, and therefore should not be construed as limiting the invention. In addition, the terms "first", "second", etc. are used for descriptive purposes only, and should no...

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 database performance optimization method. The method comprises the following steps of S1, optimizing a database file, and splitting the file; S2, optimizing query, unifying aclient and a background read-write interface, providing a database module closing interface, and adopting a pre-compilation mode for query operation; S3, optimizing file management, assigning indexesby statements, and removing invalid indexes; and S4, optimizing reading and writing: adopting a WAL log mode, single-thread writing and multi-thread reading. According to the database performance optimization method provided by the invention, the its.db file can be split into parts according to disks and time periods, so that the query speed is increased, the damage probability of the db file is reduced, and the repair cost is reduced.

Description

technical field [0001] The invention belongs to the field of embedded device big data, and in particular relates to a database performance optimization method. Background technique [0002] As a key part of the intelligent transportation solution, the traffic host is mainly responsible for receiving the front-end camera capture records, saving them locally and uploading them to the platform. At one intersection, one host is connected to 4 to 8 traffic cameras, and receives 3 to 5 vehicle passing records during peak hours, with a daily data volume of more than 200,000. With multiple large-capacity disks, the total data volume exceeds Ten million. Host devices are mostly implemented with embedded solutions, with limited resources such as cpu and memory, and the performance and stability of disks will decrease under long-term use. Under such conditions, the devices cannot meet the storage of such a large amount of data. Similarly, equipment such as face NVR and face server al...

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/13G06F16/14G06F16/16
CPCG06F16/134G06F16/144G06F16/162
Inventor 肖萌璐王健陈东亮朱健立王松
Owner TIANJIN TIANDY DIGITAL TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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