On Jan 13, Mike Castle <dalg...@gmail.com> wrote: > First, I remembered to build the DB on a file system that is NOT > journaled. This actually got me to a time similar to above. [...] > (I knew this of course,
I'd never thought that the difference would be _that_ huge. That's for sure a thing that must be documented (probably it affects other databases). > Second, I used the following command line option with OUT > transations: > -e 'BEGIN:PRAGMA synchronous = OFF;' I was disappointed to find out > that didn't help. > > On my third run, I used both that pragma and --sqlite-transactions > and got the following: Wow! If there are no reason to do otherwise, I'll add it to the actions of the --sqlite-transactions argument. > If imdbpy2sql offered up system statistics in addition to pure wall > time, that might be nice. I'll see if it can be done easily. Thank you very much for all this time spent testing! -- Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
