SQLite Performance Simple test

The main test of SQLite in the large data volume insert and query performance:

Test environment: Centos6.4 1G Internal deposit

Data volume	Size	Indexed field retrieval (time consuming)	Non-indexed field retrieval (time consuming)	Total insertion Time
006	19M	0.001s	0.036s	5.1s
50W	100M	0.0014s	0.147s	32.21s
100W	200M	0.0009s	5.277s	63.29s
200W	400M	0.0008s	12.51s	130.2s
500W	1002M	0.0016s	17.3s	513.1s
1000W	2G	0.0009s	63.0s	1278.24s
2000W	3.9G	0.0025s	134.1s	3080.6s
5000W	9.8G	0.0055s	334.078s	11745.68s

From the experimental results, SQLite still has excellent performance in tens data volume.

As an embedded database, its advantages are significant: 1. Single database file, 2. Light weight, 3. Cross-platform; 4. Support terabytes of data size; 5. Do not rely on other software.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

SQLite Performance Simple test