> I red a lot of article and documentation but I have not solved the problem.
Did you read these? http://sqlite.org/faq.html#q19 (I doubt you'll read anything really new here) http://sqlite.org/atomiccommit.html#opts (this one may be really helpful) It depends on your situation, but if it's not a business risk, you could turn off journaling, also turn off indexing while inserting, then just turn it back on at once after committing the transaction. Simon _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

