>Given the schema below, feeding a million INSERTs into the database by
>sqlite3_exec() takes about 30 minutes (this includes transactions, indices
>and "PRAGMA synchronous=off" as well as a fully optimized build of sqlite).
>Is there any chance to speed this up? Production datasets could easily bring a
>billion genotypes ...
I assumed from your description that you populate many rows in one shot. If
that is the case I recommend that you just create tables without indices and
populate the dB with the data. Then create the indices afterwards to improve
reading performance.
********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************
