Refresh is much slower than Open->Close

Zsolt Csillag · Post by **Zsolt Csillag** » Sat 19 Jan 2008 12:16

Hello,

I have a simple query:

Select * from table where field1=:param1
and field2=:param2

If I use Refresh it is about 3 seconds, if I use Close then Open then it is faster.

What is more, the table contains only 3 records!!!!
I think using 3 seconds to retrieve 3 records is pretty bad.

Have you got any idea?

Thank you

Dimon · Post by **Dimon** » Mon 21 Jan 2008 14:43

We could not reproduce the problem.
Please send a complete small sample to dmytryg*crlab*com to demonstrate it, including script to create and fill table.

Also supply us the following information
- exact version of Delphi, C++ Builder or Kylix;
- exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor.

Zsolt Csillag · Post by **Zsolt Csillag** » Mon 21 Jan 2008 18:49

Hello,

I can send the application to you but it contains QuantumGrid components for Delphi 2006.
Can you run them at your side?

Thank you

Dimon · Post by **Dimon** » Wed 23 Jan 2008 09:16

Please, try to reproduce the problem without QuantumGrid components. Change them to standard Delphi components.
If it is not possible, send the project with QuantumGrid.