On 23 Nov 2010, at 10:13pm, Paul Sanderson wrote: > I have a table with over 1 million rows and 20+ columns all of which > are indexed
Do you really need them all indexed ? You might be able to pick a few columns that people would never use as search criteria or for sorting results. Don't forget that any one SELECT command will only ever use either none or one of those indexes. Once it has picked which index to use all the others become useless for that command. > the indexing process takes about 30 minutes That's about 1.5 minutes per column, and you have over a million rows. Let's call it 11,000 rows a second. That's not bad as a speed if you're searching on a hard disk. How big is your database file when you've created the TABLE contents but not the INDEXes yet ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
