> 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

Reply via email to