*** 95,97 ****
--- 95,99 ----
SELECT * FROM tbl WHERE key = 10000;
If you use an INTEGER PRIMARY KEY instead of a PRIMARY KEY things are slightly faster all round. The relative benefit of pre-compiled queries is slightly increased (5-10%) as well.
+
+ The program to run this test is {link: http://cvs.hwaci.com/sqlite/attach_get?id=58,precomp_test.c precomp_test.c}. It builds against 2.8.5.
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|