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