holy smokes that pragma just made my several hundred inserts take half a second compared to 30 seconds earlier.
thanks! DragonK wrote: > > On 2/7/07, Ohad Eder-Pressman <[EMAIL PROTECTED]> wrote: >> >> i've got sqlite compiled with visual-studio, with all the default >> options, >> didn't touch anything. >> inserts are just a bit too slow for me, is there a good way to speed this >> up >> using some flags ? >> any other flags that it would be smart to turn on for some better >> performance ? > > > > Try using transactions for an insert and turning off synchronization via > Pragma synchronize. > > See here: http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html > > > thanks >> > > > > -- > ...it's only a matter of time... > > -- View this message in context: http://www.nabble.com/how-can-i-speed-up-inserts---tf3186848.html#a8845264 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
