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