For all columns more useful may be FTS3 extension. 2010/11/24 Paul Sanderson <[email protected]>
> I have a table with over 1 million rows and 20+ columns all of which > are indexed, I reasonably regularly recreate the table with new data > and find that the indexing process takes about 30 minutes. Are there > any settings/tweaks that I can use to reduce the time required to > create the index? > > The columns are mainly integers but with a few text columns normally > containing between 30 and a 1000 characters. > > Thanks > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
