SQLite Forum

Performance Issue: How can I increase a performance?
Regarding:  " It's just a SQLite command you execute like CREATE INDEX. "

I feel sure Simon was thinking of "EXPLAIN".  For the sqlite analyzer visit the download page:

<code>     <https://www.sqlite.org/download.html></code> 

and download the "bundle of command-line tools" for your machine, or compile from source as needed.

The analyzer is a separate program you'll run from your commandline ("terminal") as follows:

<code>     sqlite3_analyzer  filespecOfYourDatabase >MyAnalyzeOutput.txt</code>

Then post here the contents of MyAnalyzeOutput.txt, or link to it from somewhere like pastebin.com.

Unrelated question:  The field "attributes" is labeled JSON. Is this field's contents always small?