On Wed, Nov 9, 2011 at 12:04 PM, Fabian <fabianpi...@gmail.com> wrote: > 2011/11/9 Simon Slavin <slav...@bigfraud.org> >> Didn't someone recently note that entering the first million records was >> fast, but if he then closed and reopened the database, entering the next >> 100,000 records was slow ? >> > Yes, and there is still no real explanation for it, other than slow disk > reads. But even with very slow random disk I/O, 30 seconds seems still way > too slow for a 100MB file.
I posted some math on this assuming typical disk seek times. 30 seconds is very much less than the worst case scenario. I don't have an answer regarding FTS. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
