Re: [sqlite] When to use nested transaction?

Le lun. 18 nov. 2019 à 20:37, Amirouche Boubekki a écrit : > > I am looking for use-cases for nested transactions. When are nested > transactions useful in a single writer context? I am thinking about nested transaction in Sqlite LSM extensions. In what occasion, a nested tr

[sqlite] When to use nested transaction?

I am looking for use-cases for nested transactions. When are nested transactions useful in a single writer context? Thanks in advance! -- Amirouche ~ https://hyper.dev ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] Making SQLite LSM extension another flagship software

Hello! I want to ask whether it is feasible to make SQLite LSM extension more visible as another flagship software from the sqlite family. # Proposal - Change the name to something more memorable, for instance: okvslite (prefered), lsmlite or add-your-proposal-here - Move the code (and

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

Le jeu. 16 mai 2019 à 13:47, Amirouche Boubekki a écrit : > > 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_

Re: [sqlite] SQLITE_MAX_COLUMN should be a runtime knob for Machine Learning

Le lun. 17 juin 2019 à 14:36, Simon Slavin a écrit : > On 17 Jun 2019, at 9:14am, Dominique Devienne wrote: > > > SQLite4's LSM backend is now an extension in SQLite3 called LSM1 > > https://www.sqlite.org/cgi/src/dir?ci=trunk=ext/lsm1=tree > > > > Which has been discussed in this list before.

Re: [sqlite] SQLITE_MAX_COLUMN should be a runtime knob for Machine Learning

Le sam. 15 juin 2019 à 20:29, Simon Slavin a écrit : > On 15 Jun 2019, at 2:42pm, Dan Kaminsky wrote: > > [about the 32676 hard limit on the number of columns in a table] > > > I spent quite a bit of time hacking large column support into a working > > Python pipeline, and I'd prefer never to

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 configuratio

[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