try looking at the pragmas page and determine what you can get away with. For me, I relaxed the synchronization requirements and also the locking strictness, and I was able to boost my speeds to 80,000 records per second :) FYI, my records only consist of 6 numbers and a binary.
On Wed, Dec 3, 2008 at 12:23 PM, Stephen Woodbridge <[EMAIL PROTECTED] > wrote: > Oyvind Idland wrote: > > Hi, > > > > I am fiddling around with the r-tree module a bit, which works great and > > gives the effect I am looking for. > > > > The only thing is that I wish I could speed up inserts. Populating the > > rtree-index with 1 million objects > > takes about 180 seconds (using prepared statements). > > > > Is there any trick to speed up the inserts here ? > > You should be doing all your inserts inside a transaction. > > begin; > > <loop on inserts> > > commit; > > -Steve > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users