SQLite Forum

Performance Issue: How can I increase a performance?
- Please, help me. How I should run ANALYZE? I just do a query as ANALYZE?
- I put it above
- I'have 33 million rows of the table
- Yes, I did. I've created the index (list_id, item_id, modified_date_time). Is the order of these fields important?