Re: [sqlite] R-tree index database

2014-07-15 Thread Clemens Ladisch
Grzegorz Sikorski wrote: > On 15/07/14 16:13, Clemens Ladisch wrote: >> Grzegorz Sikorski wrote: >>> I have a database file with single virtual table storing R*tree index. >>> There is very strange behaviour I observe: the more rows I put into >>> this table the longer sqlite3_open_v2 operation on

Re: [sqlite] R-tree index database

2014-07-15 Thread Clemens Ladisch
Grzegorz Sikorski wrote: > I have a database file with single virtual table storing R*tree index. > There is very strange behaviour I observe: the more rows I put into > this table the longer sqlite3_open_v2 operation on the database takes. SQLite does not read table contents when opening a

[sqlite] R-tree index database

2014-07-15 Thread Grzegorz Sikorski
Hi, I have a database file with single virtual table storing R*tree index. There is very strange behaviour I observe: the more rows I put into this table the longer sqlite3_open_v2 operation on the database takes. The database open/close performance hit is huge and growing linearly with the