On 30 Dec 2011, at 2:53pm, Rick Guizawa wrote: > Using shell sqlite3.exe to process the insert took a long time to > complete. Table b has about 50000 rows and table c has about 80000 > rows of data. How can I speed up my insert?
Run ANALYZE on your database: <http://www.sqlite.org/lang_analyze.html> Create indexes appropriate to your SELECT commands: <http://www.sqlite.org/lang_createindex.html> For instance, to speed up this part of your query: SELECT MAX(Frequency) FROM c WHERE item = x.Item Make this index: CREATE INDEX cif ON c (Item,Frequency) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
