KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm trying to diagnose why a particular query is slow against SQLite. There seems to be plenty of information on how the query optimizer works , but scant information on how to actually diagnose issues. In particular, when I analyze the database I get the expected sqlite_stat1 table, but I don't know what the stat column is telling me. An example row is: MyTable,ix_id,25112 1 1 1 1 What does the "25112 1 1 1 1" actually mean? As a wider question, does anyone have any good resources on the best tools and techniques for diagnosing SQLite query performance? Thanks
Tags (comma-separated)
Save Edits
Cancel