gqt icon indicating copy to clipboard operation
gqt copied to clipboard

Creating sample database on disk very slow

Open jeromekelleher opened this issue 9 years ago • 0 comments

It appears that Sqlite is flushing to disk quite aggressively, which makes importing large pedigree databases extremely slow. Even on an SSD, it takes a very long time to run the inserts even though the CPU load is low. Running all the inserts within a transaction would probably speed things up quite a lot.

jeromekelleher avatar Jul 14 '16 09:07 jeromekelleher