-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 06/15/2010 07:59 PM, Simon Slavin wrote: > The standard assumption about SQLite is that it's faster to do your INSERTs > first, then create the indices.
If the index is created first then the data in the table and the pages making up the index will be interleaved. That is likely to lead to more and further seeks on accessing the index. Creating the index afterwards will result in a contiguous sequence of pages (assuming no existing free pages). Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkwYS94ACgkQmOOfHg372QQqngCeJ2itOBTZmY2gGVzk4CKCQWPc ZMwAn0fZ1fO+ID4K8Ak65RZBrtV03Te3 =a+mh -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users