Devart Forums

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

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.

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

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.