Try it. You might find that it executes in a similar time and it will
still be ACID and safe.
ohadp wrote:
luckily this isn't mission critical failure, i'll take the risk that one out
of ten thousand users experiences database corruption.
i can only batch the inserts into maybe 4-5 a time, don't know how much of
an improvement that will be...
Dennis Cote wrote:
ohadp wrote:
holy smokes that pragma just made my several hundred inserts take half a
second compared to 30 seconds earlier.
thanks!
Yes, but now your database can be corrupted by a power failure or OS
crash.
Wrapping several hundred inserts in a transaction will be nearly as fast
and completely safe.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------