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

Michael Van Canneyt michael at freepascal.org
Mon Aug 1 20:56:17 CEST 2011



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.




More information about the Lazarus mailing list