Did you try to raise value of cache_size? Do you execute any other queries on the same database besides INSERT?
Pavel On Tue, Mar 9, 2010 at 12:09 PM, Kiril <kirilstan...@gmail.com> wrote: > Hi all, > > I am facing performance issues after few thousand inserts. > I have a DB with 3 tables, few columns each, each one has auto-increment ID. > These tables are joined by ID, so after each INSERT, I read back the > last_insert_rowid() from 2 tables. > One or two columns per table are indexed. > > I am using transaction, of course. Also - set PRAGMA synchronous = 0 > > All works pretty fast at the beginning - ~300 INSERTS per second, but then > progressively performance drops down to 20 INSERTS per second as the DB > grows to 200 Mb in size > > Any idea why and if this is expected behavior? > Fixes? Am I doing something wrong? > > Thanks in advance, > > Kiril. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
