Ok I hadn't toyed with those. Just tried it, the speed for queries hasn't increased much, but a little
However, I started getting hard drive thrashes for 10+ seconds from time to time. Will investigate the cahce further to see what suits this app > Did you try increasing the page cache size. Your data set is very big. > > pragma page_cache = 20000; > > This should at least improve the speed for queries.