mailing list <sqlite-users@mailinglists.sqlite.org>
Betreff: Re: [sqlite] [EXTERNAL] R*Trees query data cached?
Thanks Gunter. Below are the execution times:
pragma table_value(pragma table_info(adas_link_geometry) 2mspragma
table_value(pragma table_info(idx_adas_link_geometry) 1msSELEC
Dienstag, 20. März 2018 22:45
An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Betreff: Re: [sqlite] [EXTERNAL] R*Trees query data cached?
Thank you for the quick reply Hick. I've implemented your script file in C
since I'm running this application in the embedded world with no
2018 22:45
An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Betreff: Re: [sqlite] [EXTERNAL] R*Trees query data cached?
Thank you for the quick reply Hick. I've implemented your script file in C
since I'm running this application in the embedded world with no OS. I don'
On Tue, Mar 20, 2018 at 10:45 PM, David Ashman - Zone 7 Engineering, LLC <
da...@zone7engineering.com> wrote:
> I don't see a .describe in the SQLite documentation. I've tried to use
> .schema but that returns an error.
>
.describe [3] and .schema [2] are "dot-commands" of the sqlite3 command
the table
information you had in mind?
From: Hick Gunter <h...@scigames.at>
To: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org>
Sent: Tuesday, March 20, 2018 9:04 AM
Subject: Re: [sqlite] [EXTERNAL] R*Trees query data cached?
SQLite does not have &q
SQLite does not have "query caching". It does have a "page cache" that will
keep heavily used pages iin memory. There is also the possibility of a
file-system/os-level cache. To break down the 1.6 seconds required for the
first query, try executing an sql script. In linux this would be along
6 matches
Mail list logo