How many indexes on your data? Can you DROP your indexes for the insert, then CREATE INDEX them again after all the content is in place?
-- D. Richard Hipp drh at sqlite.org
- [sqlite] Insertion into the large DB drastically slows... Yuri
- [sqlite] Insertion into the large DB drastically ... Simon Slavin
- [sqlite] Insertion into the large DB drastica... Stephen Chrzanowski
- [sqlite] Insertion into the large DB dras... Richard Hipp
- [sqlite] Insertion into the large DB drastica... Yuri
- [sqlite] Insertion into the large DB dras... Simon Slavin
- [sqlite] Insertion into the large DB drastically ... R.Smith
- [sqlite] Insertion into the large DB drastically ... Yuri
- [sqlite] Insertion into the large DB drastically ... Clemens Ladisch
- [sqlite] Insertion into the large DB drastica... Sergej Jurečko
