On 29 Oct 2011, at 5:57pm, Fabian wrote: > I have a table with one TEXT column. I insert 1 million rows of short > strings, and then create an UNIQUE INDEX. The speed is very acceptable. Then > I insert another 10.000 short strings, and the performance is very bad, it > almosts take longer than inserting the initial million(!) rows to fill the > table.
When you insert the 10,000 strings are you doing it inside a transaction ? BEGIN TRANSACTION; INSERT ... INSERT ... INSERT ... COMMIT; Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
