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
