> > This may take a while, about 20 hours maybe. The partition has approx > > 10GB, I can't afford more. Let's hope that this is sufficient. > > Import data without indexes, then add then when the import is complete. > It's much faster.
Thanks. I can not do this with the real data, unfortunatelly. The index has a uniqueness constraint. If there is a file that violates this restriction, I have to reject the file completely. Each file is translated into a set of statements like these: BEGIN transaction; INSERT OR ROLLBACK ... ... COMMIT; I still have to check the sqlite3_bind_* functions instead ...