Wes, I gather you are using version 3.6.14 in this test (?) Please also try version 3.6.15 since I'm seeing drastically different behavior using that version (starting similarly fast as .14 but quickly slowing down after about 15 iterations and then leveling off after 22 iterations).
JP -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Wes Freeman Sent: 16. júní 2009 18:01 To: General Discussion of SQLite Database Subject: Re: [sqlite] Database inserts gradually slowing down I also wrote my own test in a small Qt/C++ app. First I tried on my 10k rpm U160 SCSI drive, and it stayed roughly between ~23 seconds per set (one set is 100 of: start transaction->insert 1000->commit, as described). I let it run for about 10 minutes before stopping it. It's hard drive bound on this drive, taking only about 20% of one of the CPU cores, and creating a horrible-sounding disk churning noise. Second, I tried on my two raid 0 (striped for performance) 7200rpm drives, and it was much faster--~4.5 seconds per set. It does seem to be increasing, but I'm only up to 200 iterations, so it's difficult to tell if it's significant. It seems to be CPU bound for this test, as it's maxing one of my cores at 95-100% (Intel Core 2 Quad @2.66GHz w/ 12MB cache). I'm disappointed with the performance of my "faster" drive, but I guess this is a good showing for the benefits of raid 0. I'm wondering if my SCSI drive has some issues at this point. I'll continue testing over longer periods to see how much worse it gets on my system. Konrad's comment on fragmentation sounds like a reasonable explanation. I'm curious about a non-transactional test, to see if this occurs at a single-insert level. This may be something to keep in mind when writing an application that will use a database file transactionally for months at a time. Wes _______________________________________________ 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
