[sqlite] SQLite v3.27.2 memory usage

Hello - I have a question on SQLite memory usage. I'm successfully using SQLite v3.27.2 amalgamation on an embedded ARM processor from STMicro with SD card and no OS.  The database file size is about 3.8GB.  The file system is Segger emFile FAT32.  I've configured SQLite to use 3.7MB RAM for

Re: [sqlite] [EXTERNAL] R*Trees query data cached?

s query data cached? The .describe is just to make sure the SQLite has loaded the table definition. Try pragma table_info(); -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von David Ashman - Zone 7 Engineering, LLC Gesendet:

Re: [sqlite] [EXTERNAL] R*Trees query data cached?

rs-boun...@mailinglists.sqlite.org] Im Auftrag von David Ashman - Zone 7 Engineering, LLC Gesendet: Dienstag, 20. März 2018 16:34 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] R*Trees query data cached? Hello - I have a question on SQLite query data buffering. I'm successfully u

[sqlite] R*Trees query data cached?

Hello - I have a question on SQLite query data buffering. I'm successfully using SQLite v3.22.0 on an embedded ARM processor from ST with SD card.  The database file size is about 750MB.  The file system is Segger emFile FAT32.  I've configured SQLite to use 6MB RAM for heap.  I've done some