You need to provide some more info...
#1 What version? #2 How long to insert the 1M? #3 What's the average string size? #5 How long to create the index? #6 How long to insert the next 10,000? And your stated problem is simple enough you should be able to create a complete stand-alone example so we can all see and test what you're (presumably) doing wrong. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Fabian [fabianpi...@gmail.com] Sent: Saturday, October 29, 2011 12:11 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Slow inserts with UNIQUE 2011/10/29 Simon Slavin <slav...@bigfraud.org> > > When you insert the 10,000 strings are you doing it inside a transaction ? > > BEGIN TRANSACTION; > INSERT ... > INSERT ... > INSERT ... > COMMIT; > > Yes, I use transactions, prepared statements, cache_size, journal_mode and synchronous PRAGMA's, almost everything you can think of to make it faster. But most important: I use the exact same code to fill the initial million rows, so if there was anything wrong, the initial filling would be slow too I suppose? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
