On 8 Feb 2012, at 10:22pm, Oliver Peters wrote: > It's the Primary Key that you're using cause for every INSERT it is checked > if unix_time is already present in a record. > > So the question is if you really need unix_time as a PK
If you're batching your INSERTs up into transactions, try doing a VACUUM after each COMMIT. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
