Re: [sqlite] VFS FCNTL question

2017-12-03 Thread Cezary H. Noweta
Hello, On 2017-12-03 17:41, J Decker wrote: https://sqlite.org/c3ref/c_fcntl_busyhandler.html #define SQLITE_FCNTL_PDB 30 SQLITE_FCNTL_PDB has no documentation as to what it's for. The only place, where this FCNTL is used, is btree.c:sqlite3BtreeOpen(). The FCNTL informs a VFS driver on

Re: [sqlite] Simple read-only program very slow

2017-12-03 Thread Keith Medcalf
On Sunday, 3 December, 2017 08:24, Richard Rousselot wrote: >Had similar issue a few years ago; we were using the SQLite3.exe. We >recompiled the exe as 64 bit which allowed it to use more than 4 GB >of ram, loaded the machine with as much memory as we could.

[sqlite] VFS FCNTL question

2017-12-03 Thread J Decker
https://sqlite.org/c3ref/c_fcntl_busyhandler.html #define SQLITE_FCNTL_PDB 30 SQLITE_FCNTL_PDB has no documentation as to what it's for. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Simple read-only program very slow

2017-12-03 Thread Richard Rousselot
Had similar issue a few years ago; we were using the SQLite3.exe. We recompiled the exe as 64 bit which allowed it to use more than 4 GB of ram, loaded the machine with as much memory as we could. Voila, super fast processing. Can the Python libraries be made 64 bit some how? On Thu, Nov 30,