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] > ----------------------------------------------------------------------------- > > > -- View this message in context: http://www.nabble.com/how-can-i-speed-up-inserts---tf3186848.html#a8849056 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------