Re: [sqlite] performance difficulty across multiple queries

>I recommend you execute the SQL command ANALYZE then try various of those SELECTs again. This can cause the SQLite optimizer to make different choices about which indexes to use. Thanks for the suggestion. I am familiar with the Analyze command and have been using it. However, it doesn't seem

Re: [sqlite] performance difficulty across multiple queries

On 31 May 2012, at 6:18pm, Brannon King wrote: > The Services and Telemetry tables have hundreds of rows, but the Events > table has a million. I can't seem to figure out the right combination of > indexes to get the following queries to all execute quickly. Some indexes >

[sqlite] performance difficulty across multiple queries

I've got this (simplified) table schema: CREATE TABLE [Services] ([Id] INTEGER PRIMARY KEY, [AssetId] INTEGER NULL, [Name] TEXT NOT NULL); CREATE TABLE [Telemetry] ([Id] INTEGER PRIMARY KEY, [ServiceId] INTEGER NULL, [Name] TEXT NOT NULL) CREATE TABLE [Events] ([Id] INTEGER PRIMARY