Re: [sqlite] SQLite Select Optimization help

Hello! > On a database of 2.5 million records, it ran over 11 hours before I killed > it. On smaller datasets it works fine. > Any Advice? See explain query plan for indices usage. And query Select filename, accessCount from   (     SELECT eventTime, Upper(AuditRecords.fileName) fileName,  

[sqlite] SQLite Select Optimization help

Good morning all, I'm wondering if someone can help me with my incredibly slow select statement. My program executes a SINGLE select statement and then generates a report based on the output. So far, it's worked great..until now. Yesterday, I wanted to add a new report that lists all