Hi Trax, On Sun, 21 Oct 2007 20:44:12 +0200, you wrote: >Hello,
>I made a "hello world" program in order to test SQLite, but it is very >slow : >I am trying to set 1000 INSERT in a database. The time average is 2m30s >on a AMD Athlon(TM) XP 2400+ with 1Go Ram >however http://www.sqlite.org/speed.html > >My code >http://pastebin.ca/744623 If you need speed you will have to use transactions. BEGIN; INSERT ....; -- thousands of rows COMMIT; Without it, every INSERT is a separate transaction (auto commit) More info: http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning >Regards > >trax -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
