>> In any case, you set the cache size in pages by executing "PRAGMA >> cache_size=<pages>" after opening the database connection.
I am using "PRAGMA cache_size=-3000000" to set the cache to 3G, but the process is still slow-going using 23M of RAM, despite the fact that it is reading small pieces of all tables of a database of 62G... I will try to see what is going on. Cheers, Bo _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
