Re: [sqlite] LSM Extension Performance (from sqlite3 tree)

On 16 May 2019, at 3:51pm, Amirouche Boubekki wrote: > I can create a small program that read the key/value pairs from a file that > you would be able to re-use in another program written in C for instance. Can you create a small program which shows the problem you are complaining about ?

Re: [sqlite] LSM Extension Performance (from sqlite3 tree)

Le jeu. 16 mai 2019 à 15:46, Dan Kennedy a écrit : > > On 16/5/62 18:47, Amirouche Boubekki wrote: > > Hello, > > > > > > I am considering using lsm extension for a project. I a did a few > benchmark > > with the following configuration: > > > > LSM_CONFIG_AUTOFLUSH 1048576 > >

Re: [sqlite] LSM Extension Performance (from sqlite3 tree)

On 16/5/62 18:47, Amirouche Boubekki wrote: 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

[sqlite] LSM Extension Performance (from sqlite3 tree)

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