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. -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
