On 4 Feb 2013, at 12:02am, Paul Sanderson <sandersonforens...@gmail.com> wrote:
> currently using : > journal_mode = off > page_size=16386 > cache_size = 10000 > synchronous = off Reasonable. > 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 Note that unless you all have identical hardware, the settings which will make your computer do it fastest are not necessarily the same settings that will make your customers' computers run fastest. > Trial and error seems to indicate that this works best - but interesed in > others views. The thing that's likely to speed that operation up most is switching from rotating hard disks to SSD. If saving that amount of time is that important to your customers, that's what they'll do. If they're not willing to pay the extra for an SSD in their own computer, they're probably not willing to pay you for your testing and programming time. On the other hand if you're all already running SSDs you've already taken the big step and sorry for wasting your time. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users