On 4 Aug 2015, at 6:35pm, Scott Hess <shess at google.com> wrote: > BUT, keep in mind that you might find that you've just moved the 1min time > from query time to preload time, in which case you've just complexified > without adding anything.
That's why I didn't give any advice. /Something/ has to load those sectors from main storage and whenever that is done, that's when the extra 57 seconds is going to happen. It could be tested, of course. Make a source file which is ten times that length and see if it takes 10 minutes the first time and 30 seconds subsequent times. I doubt that a database with 10 million rows could all fit in the cache. Simon.
