SQLite performance on Linux is long

Said a website evaluated the performance of a series of desktop software on the Linux kernel, using a series of pure kernels from the Ubuntu company without patching, from 2.6.24 to 2.6.29, other software is standard Ubuntu 8.10, including X Server 1.5.2, GCC 4.3.2, GNOME 2.24.1, xf86-video-intel 2.4.1, Mesa 7.2, EXT3 file system.

Among the performance related to many desktop applications, two significant improvements have been made. One is the RSA 4096-bit signature of OpenSSL, which doubles the performance from 2.6.28 to 2.6.29, and the other is SQLite, the time for executing the 12500 database insert operations has returned to the 2.6.24 time level, which is much less than the 27/28 S in 2.6.26/100, and only takes 28 seconds.

The performance of SQLite is critical because more and more software are used, and the famous one is Firefox, it stores all the records of user browsing history, bookmarks, searches, downloads, and so on in the SQLite database. If the performance is low, it is terrible. In the past, we had to disable the largest urlcassifier feature for distinguishing against vulgar and dangerous websites. Later, we found that the famous Awesomebar, that is, the function of automatically and intelligently matching user input in the address bar, was terrible, and the response was too slow. Good machines may not be obvious, an old machine like T40 cannot stand it, so it has to close the matching item to 0, but it is not good. It has to go to 2 or 3, and it seems better.

At that time, when Firefox 3 was launched, it happened to be 2.6.26, which seems to be a poor performance. It is said that the reason is the file system on Linux and so on. Wait until 2.6.29 enters Debian, let's see if the performance has been improved.

Before that, someone found a SQLite operation, VACUUM command, which is about to sort and sort the database. It may be faster after sorting.

The above Ubuntu blog shows a script. Every time you start Fx, you can sort out the sqlite database under the Profile directory, which should be very useful. My Places. sqlite is 13 MB in size and 3 MB in size. It seems faster to use it in the address bar.

Command: sqlite3 places. sqlite 'vacuum ;'.

Cathayan.org is copyrighted and reserves all rights. Reprinted please keep this description. Decline commercial reprinting.