On May 8, 2009, at 9:45 AM, J. R. Westmoreland wrote: > I have a program that creates a database with a number of tables and > a few > indexes. > > I'm just inserting in this program and not doing any lookups. > > I create the indexes after all records have been inserted. > > The input for the database is a LARGE number of records. > > > > The data is mapping data for the U.S. and therefore contains > millions of > entries. > > The current run is taking about three days for the entire U.S. to > complete. > > A single state, say California, is taking several hours. > > > > Any suggestions on speed-ups? >
http://www.sqlite.org/faq.html#q19 D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users