SQLite 3.8.7 a large number of minor optimizations, improving performance by more than 50%
News]SQLite 3.8.7alpha was released. This version contains hundreds of minor optimizations. Each of the minor optimizations will increase the performance by at least 0.05%, increasing the performance of the entire SQLite database by more than 50%, the query speed is also 5 times faster. For details, see the release notes. Http://permalink.gmane.org/gmane.comp.db.sqlite.general/90549)
What is SQLite?
SQLite is an ACID-compliant relational database management system, which is contained in a relatively small C library. It is a public project established by D. Richard IPP.
Unlike the common client-server example, the SQLite engine is not an independent process for communications between programs, but a major part of the connection to programs. Therefore, the main communication protocol is direct API calls in programming languages. This plays a positive role in total consumption, latency, and overall simplicity. The entire database (definition, table, index, and data itself) is stored in a single file on the host. Its simple design is completed by locking the entire data file at the beginning of a transaction.
: Http://www.sqlite.org/download.html