I would like to stick my neck out over the chopping block and agree. My experience is the opposite, but appears to support Puneet's assertion. With me, it takes my C# application 12 seconds to pass 103,00 records and insert 98,000 rows into the db from it. The next time I run the application (which starts with a fresh db,) it takes 7 seconds or less. This leads me to be believe the O/S still has the original file cached, so it's i/o performance is much improved.
dvn On Wed, Nov 2, 2011 at 11:27 AM, Mr. Puneet Kishor <punk.k...@gmail.com>wrote: > > On Nov 2, 2011, at 11:24 AM, Fabian wrote: > > > Now if I re-open the database, I can add an additional 10.000 rows very > > fast (<1 sec). But if I reboot the (Windows) PC, and insert an additional > > 10.000 rows, it takes at least 30 secs, which seems very slow, if I can > add > > the first 1 million in under 10 seconds. > > > Others will have better answers, but methinks that when you reboot the > computer, the operating system's caches are flushed out, which slows the > operation. Try working with the db for a bit (SELECT, repeat INSERTs, etc.) > and notice if the speed increases again to what you expect. > > > > -- > Puneet Kishor > _______________________________________________ > 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