> I also wrap my statements (about 500 inserts at a time) with a begin/end
> transaction.
> After these 500 i take a few seconds to read more data so sqlite should
> have time to do any housekeeping it might need.

Wrap more into a transaction. 500 is too small of a percentage of a million.

sqlite-users mailing list

Reply via email to