On 7/30/15, Jens Miltner <jum at mac.com> wrote: > Hi, > > we encountered an issue where a query that performed well using SQLite > 3.8.4.1 (i.e. execution time way below 1 second) suddenly took several > seconds to execute. > Unfortunately, I could not yet reduce the query and database to a sample > that I could send along and the real query / database is not something I can > disclose to the public. > > Also, I saw the query performance differ a lot between two databases > (containing similar amounts of records in the involved tables), so it might > be related to the correlation between the data populating the tables being > used... > > I can send you the query and information on the tables involved off list
Can you send the query and the original database file directly to me, please? -- D. Richard Hipp drh at sqlite.org