Usage of SQLite Memory Database

SQLite can not only store the database on the hard disk, but also in the memory (sqlite3_open (": Memory:", & dB). After testing, under the same conditions, the speed of storing databases in the memory is about three times faster than that of inserting records on the hard disk. However, when the database is stored in the memory, the following defects exist:

1. Power failure orProgramThe database will disappear after the crash. You need to attach the database to the hard disk regularly;

2. databases in the memory cannot be accessed by other processes (because there is no name, it may be supported later). The same handle must be used even in multiple threads;

3. read/write mutex processing on a hard disk is not supported. Lock it by yourself.

It seems that the pursuit of speed has to pay the price!