james ni wrote: > the INSERT speed is becoming slower and slower; > > the number of syscalls are increasing quickly;
Insert the largest values last. Increase the cache size: <http://www.sqlite.org/pragma.html#pragma_cache_size>. Decrease the amount of data stored in the index. (This is unlikely to be possible.) Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
