On Wed, Nov 9, 2011 at 12:04 PM, Fabian <[email protected]> wrote: > 2011/11/9 Simon Slavin <[email protected]> >> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
