On 16 Jun 2010, at 5:04am, Eric Smith wrote: > Simon Slavin wrote: > >> The standard assumption about SQLite is that it's faster to do your >> INSERTs first, then create the indices. How much of a difference this >> makes depends on a lot of things. > > On what things does it depend?
Nothing magic, just all the normal things: How many indices do you have ? How many columns in each ? How many rows in each ? Are the indexed fields 'clumpy' or not ? How fast are your CPU and storage system ? How much of three different types of cache do you have ? Is your database storage system optimized for read-ahead or write-ahead storage ? The only way to find out is to try it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
