currently using : journal_mode = off page_size=16386 cache_size = 10000 synchronous = off
I load lots of similar data sets (each into a separate db) and load time is definitely an issue. There are processing delays and loading a db can take 30+ minutes, if I can shave off even a few minutes on each run it is worth it to my customers Trial and error seems to indicate that this works best - but interesed in others views. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users