On 12/3/08, Oyvind Idland <[EMAIL PROTECTED]> 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 ?
Whereby "objects" you mean "rows," no? You are getting upward of 5500 sustained inserts per second. That sounds pretty good. That said, are you using transactions? See what difference that makes. > > > Oyvind > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
