On 14 Feb 2019, at 6:06pm, Randall Smith wrote:
> One feature that would be useful for the sqlite3 command shell would be a
> mode where the duration of the operation is reported after the operation runs
> (".timing"?).
.timer ON
Simon.
___
One feature that would be useful for the sqlite3 command shell would be a mode
where the duration of the operation is reported after the operation runs
(".timing"?). This would make it easy to compare different approaches for
writing a query, formulating and using different indices, etc. Of
Ok, thank you very much for everybody's help.
- Original Message -
From: Shawn Wagner
To: SQLite mailing list
Sent: Wednesday, February 13, 2019, 13:58:19
Subject: [sqlite] Tips for index creation
Some useful reading:
https://use-the-index-luke.com/
https://www.sqlite.org
Some useful reading:
https://use-the-index-luke.com/
https://www.sqlite.org/queryplanner.html (and the pages it links to)
There's also the .expert command in the sqlite shell:
sqlite> .expert
sqlite> SELECT ... FROM ...;
will suggest indexes that will benefit a particular query.
On Wed, Feb
On 2019/02/13 2:39 PM, Thomas Kurz wrote:
Hello,
I apologize right at the beginning, because this is a real noob question. But I
don't have much experience with performance optimization and indexes, so I'm
hoping for some useful hints what indexes to create.
I have queries like this:
On 2/13/19, Thomas Kurz wrote:
> Hello,
>
> I apologize right at the beginning, because this is a real noob question.
> But I don't have much experience with performance optimization and indexes,
> so I'm hoping for some useful hints what indexes to create.
>
> I have queries like this:
>
>
Hello,
I apologize right at the beginning, because this is a real noob question. But I
don't have much experience with performance optimization and indexes, so I'm
hoping for some useful hints what indexes to create.
I have queries like this:
SELECT parameter, value FROM metadata WHERE id1=a
7 matches
Mail list logo