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 the database takes. >> >> SQLite does not read table contents when opening a database. > > Sorry, maybe I was not very clear. Adding calls to open/close over > insert statements operation heavily increases the total insert time > (including open/exec/close).
Closing a database also throws away its page cache. > What is strange here, if I add open/close calls around another > databases that hold only raw SQLite3 tables, the overhead in similar > scenario is negligible. 'Normal' tables can just append new records at the end; this is not possible in R-trees. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
