On Sat, 12 Nov 2011 08:21:15 -0800 (PST), yqpl
<y...@poczta.onet.pl> wrote:

>
>ie im loading 1000 files.
>
>first rows it is even speeding up the initial speed - 25 files / sec -
>speeds up to the 30 files/ sec in 50 files.
>then is starts to slow down evenly (regular slow down for some number of
>files) until 2 files/ sec at the end - 1000 files.
>
>every next time it looks the same :   
>"first rows it is even speeding up the initial speed - 25 files / sec -
>speeds up to the 30 files/ sec in 50 files.
>then is starts to slow down evenly (regular slow down for some number of
>files) until 2 files/ sec at the end - 1000 files."

I hope you don't open and close the database connection for every
file? It will invalidate the cache and the parsed schema.

Open the database before the first file, close it after the last
file, bundle some 10000 to 50000 insert statements per
transaction.

-- 
  (  Kees Nuyt
  )
c[_]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to