A database writing method and device

Abstract

The invention provides a writing method and a writing device of a database. The writing method of the database includes: obtaining a file to be written into the database; writing the file into the database through at least two writing operations so as to allow a reading operation on the database within time between each two adjacent writing operations. The writing method and the writing device of the database achieve time division multiplexing of resources in the database, and guarantee normal execution of the integral writing operations and can not obviously increase time of the integral writing operations due to the fact that time of the reading operations is short and only of millisecond level. On the one hand, the time of each writing operation is shorter than the time of the integral writing operations, waiting time for the reading operations is reduced, operation efficiency is improved, and the quantity of problems that an interface is in a waiting state for a long time and the like is decreased; on the other hand, due to the fact that the reading operations and the writing operations are executed in series, a deadlock probability and consumption to a memory, caused by concurrence of the writing operations and the reading operations, are reduced.

Description

technical field [0001] The invention relates to the technical field of communication, in particular to a database writing method and a database writing device. Background technique [0002] With the development of communication technology, smart terminals such as mobile phones and watches are increasingly used in people's work, study, and daily communication. [0003] Many applications running on smart terminals use databases (such as SQLite) to store user-operated data, especially social applications, such as instant messaging tools, SMS applications, etc., need to write a database in the background thread, and at the same time need to The main thread displays data on the UI (User Interface, user interface), then the main thread will generate sub-threads, and the same database is read in the sub-threads. [0004] Although the object of the read operation and the object of the write operation are not the same table, the locks used by databases such as SQLite are file locks....

AI Technical Summary

Problems solved by technology

[0009] In view of the above-mentioned problems, in order to solve the problems that the above-mentioned database write operation time is too long to cause the read operation execution time to be too long, the parallel reading and writing increases the deadlock probability, and the problems of memory consumption, the embodiment of the present invention proposes a database writing method and A corresponding database writing device

Images