[Lazarus] I thought it was solved -- TQuery.Open very slow.

[Michael Van Canneyt]

On Mon, 1 Aug 2011, Howard Lee Harkness wrote:

> I thought I had fixed the performance problem, but it is still there.
> What I am doing is opening 3 dependent queries after selecting a
> record in the main table. It takes 8 or 9 seconds to do the 3 calls to
> TQuery.Open. Any clues as to what I might be doing wrong? The sample
> queries done from sqlite3.exe return instantaneously, so I am
> concluding that I have not set something up correctly in the LCL.

Can you provide test data and a sample program ? 
Without that, it's very hard to give recommendations.

The architecture of the sqlite components is not fundamentally different from
the other database, and those do work instantaneously.

Michael.