Hi Dan,

Perhaps it's just my uneducated opinion but your explanation sounds bogus... Why would the folks who wrote SQLITE show it off as being so fast if, under win 2000, it only added 200 records every 25 seconds????
It doesnt take anywhere near that long when you wrap the inserts in a transaction, right?

> And, why does adding a begin: / end:commit: around the whole loop speed
> up the operations so drastically???
You need to read the wiki:
http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning

Eugene Wee

Reply via email to