Hello,
I am considering using lsm extension for a project. I a did a few benchmark with the following configuration: LSM_CONFIG_AUTOFLUSH 1048576 LSM_CONFIG_BLOCK_SIZE 65536 LSM_CONFIG_AUTOWORK 1 LSM_CONFIG_MMAP 0 LSM_CONFIG_MULTIPLE_PROCESS 0 I am trying to load 4.5GB of data. The database errors with BUSY error at some point. Also, the memory consumption grows unbound even if I diseabled MMAP. Here is some stats: $ ls -larh wt/foob.ar.lsm.sqlite* -rw-r--r-- 1 amirouche amirouche 618M May 16 13:39 wt/foob.ar.lsm.sqlite-log -rw-r--r-- 1 amirouche amirouche 468M May 16 13:39 wt/foob.ar.lsm.sqlite And I attached a memory plot. opening and closing the database at each transaction help, but still the memory grows. What I am doing wrong? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
