On February 12, 2011, Black, Michael (IS) wrote: > Are you wrapping your data dump into a "BEGIN" "COMMIT"?
Yup. > Also...you mention using a select...I assume you are testing first to see > if you need to update or insert? The select is not used when dumping data. The in memory data structure knows if an entry hasn't been saved yet (id == 0), calls INSERT if it hasn't and UPDATE if it has. > You may want to look at the REPLACE clause and see if you can use that. That's an option. [snip] After working on my error handling a bit last night, the problem seems to be gone now. I tell the program to sync its data, and it takes 2-5 100ths of a second, rather than several seconds. At the moment I can't find the exact change that fixed it, but performance is more in line with what I'd expect with `PRAGMA synchronous=off` set. > > Michael D. Black > Senior Scientist > NG Information Systems > Advanced Analytics Directorate > -- Thomas Fjellstrom tfjellst...@strangesoft.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
