Re: [sqlite] R*Tree performance

2018-10-22 Thread Zoltan Demeter
Hello there, thanks for the responses. Indeed, I don't have anything to compare the performance to. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] R*Tree performance

2018-10-22 Thread Dominique Devienne
On Mon, Oct 22, 2018 at 2:03 PM Richard Hipp wrote: > On 10/22/18, Zoltan Demeter wrote: > > I have a rather poor performance of 50 k inserts per second. The data > > to be inserted is precalculated and passed to the loop. I am using the > > same logic as above, so the loop is wrapped in a trans

Re: [sqlite] R*Tree performance

2018-10-22 Thread Richard Hipp
On 10/22/18, Zoltan Demeter wrote: > > I have a rather poor performance of 50 k inserts per second. The data > to be inserted is precalculated and passed to the loop. I am using the > same logic as above, so the loop is wrapped in a transaction and I use > a parametrized statement. > Inserting in

[sqlite] R*Tree performance

2018-10-21 Thread Zoltan Demeter
Hello there, I would like to get an idea, what (insert) performance I could expect when building a 3-dimensional (float) R*Tree. I am using SQLite as a static lib, compiled with the following defines: "SQLITE_ENABLE_RTREE" "SQLITE_OMIT_DEPRECATED" "SQLITE_THREADSAFE=2" "SQLITE_MAX_EXPR_DEPTH=0"