测试 6: 创建索引 ................................................................... 27
测试 7: 没有索引的 5000 SELECTs .................................................... 27
测试 8: 没有索引的 1000 UPDATEs .................................................... 28
测试 9: 有索引的 25000 UPDATEs ..................................................... 28
测试 10: 有索引的 25000 text UPDATEs ............................................... 28
测试 11: 来源于 SELECT 的 INSERTs ................................................... 29
测试 12: 没有索引的 DELETE ......................................................... 29
测试 13: 有索引的 DELETE ........................................................... 29
测试 14: 一个大 DELETE 之后的一个大 INSERT.......................................... 30
测试 15: 一个大的 DELETE 及许多小 INSERTs ........................................... 30
测试 16:DROP TABLE................................................................ 30
SQLite 中的空处理与其它数据库引擎的比较 .............................................. 31
SQLite 数据库的速度比较 (wiki)........................................................ 34
Test 1: 1000 INSERTs ............................................................. 36
Test 2: 25000 INSERTs in a transaction ........................................... 36
Test 3: 25000 INSERTs into an indexed table ...................................... 37
Test 4: 100 SELECTs without an index ............................................. 37
Test 5: 100 SELECTs on a string comparison ....................................... 38
Test 6: INNER JOIN without an index .............................................. 38
Test 7: Creating an index ........................................................ 38
Test 8: 5000 SELECTs with an index ............................................... 39
Test 9: 1000 UPDATEs without an index ............................................ 39
Test 10: 25000 UPDATEs with an index ............................................. 39
Test 11: 25000 text UPDATEs with an index ........................................ 40
Test 12: INSERTs from a SELECT ................................................... 40
Test 13: INNER JOIN with index on one side ....................................... 41
Test 14: INNER JOIN on text field with index on one side ......................... 41
Test 15: 100 SELECTs with subqueries. Subquery is using an index ................. 41
Test 16: DELETE without an index ................................................. 42
Test 17: DELETE with an index .................................................... 42
Test 18: A big INSERT after a big DELETE ......................................... 42
Test 19: A big DELETE followed by many small INSERTs ............................. 42
Test 20: DROP TABLE .............................................................. 43
附加文件 ...................................................................... 43
SQLite 在 Windows 中的性能调试 ........................................................ 44
直接使用 SQLite................................................................... 44
2 ： Indexes 和数据库结构是非常重要的。 ............................................ 44
3 ：页面规模也很重要 .............................................................. 45
4 ：成群的索引 .................................................................... 45
5 ：作为读这篇文章的收获，这里有个不智能的事情需要提醒你。 ........................ 46
SQLite 中如何用触发器执行取消和重做逻辑 .............................................. 47
SQLite3 C/C++ 开发接口简介（ API 函数） ............................................... 55
1.0 总览 ......................................................................... 55
2.0 C/C++ 接口 ................................................................... 55
如何在 VS 2003 下编译 SQLite .......................................................... 61
下载 ............................................................................. 61
创建一个 DLL 工程 ................................................................ 61
2 / 123
