Roger Binns wrote: >Are you using a 32 bit or 64 bit process.
32, but it does not matter to the problem. >Also is there a requirement to create the database in the filesystem? Yes. >If not you could ensure your swap is sufficiently large (I use a mininmum of >16GB on my machines :-) and create in a tmpfs filesystem, and then copy the >database to >persistent storage when you are done. The aim is to avoid slow swap memory but use fast RAM only. >You also didn't list turning off synchronous etc while creating the database >and turning it back on when done. Performance settings are: * PRAGMA locking_mode=exclusive; * PRAGMA synchronous=off; * Disable journal file :-) >I am curious why you think memory is the bottleneck anyway! It has often been pointed out on this list that inserts into indexed tables (regular or FTS) run faster with a high page cache. My own tests 2nd this. A few 100 MB more or less can make an difference of more than 100%. Ralf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users