Hello ohadp, Well, my experience is, particularly when it's users using it and not a personal project, that corruption happens fairly frequently when you use this pragma. That's why I don't use it any more in my production code.
Transactions are far safer and fast too. C Wednesday, February 7, 2007, 11:39:26 AM, you wrote: o> luckily this isn't mission critical failure, i'll take the risk that one out o> of ten thousand users experiences database corruption. o> i can only batch the inserts into maybe 4-5 a time, don't know how much of o> an improvement that will be... o> 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] >> ----------------------------------------------------------------------------- >> >> >> -- Best regards, Teg mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
