Re: Inserts get slower and slower

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@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users