ohadp wrote:
luckily this isn't mission critical failure, i'll take the risk that one out of ten thousand users experiences database corruption.
Only you can judge how important your data are.
i can only batch the inserts into maybe 4-5 a time, don't know how much of an improvement that will be...
That should speed things up by a factor of about 4 to 5. If you do not use explicit transactions, SQLite (at least in effect) does one implicitly per insert. The time per transaction will not go up a whole lot unless you do _many_ inserts in each one.
If you really can't get more than 4-5 in a batch, it's your call whether the time saving is worth the risk. BTW, the problem rate should be much less than one in ten thousand.
Gerry ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
