Hello,
I do millions of inserts in one transaction, and have tried many
different pragmas.
pragma cache_size had very little impact on the speed of inserts (around
2%).
I think the size of the records might play a role here (mine are around
100 -200 bytes).
However, PRAGMA synchronous = OFF is very important.
Martin.
deb f schrieb:
I'd like to improve the speed of inserts (am inserting in a
transaction) and would like to change my pragma cache_size to
help.
Are there any recommendations with how to come up with the right
cache_size value?
thx
________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag