Very Slow at closing a query with FetchAll = False, when Fix go make...

[eduardosic]

We will try to add this capability in nearest build.

Thanks, I and many other users we go to be waiting anxious.

Eduardo S Santos. 19-01-06

[eduardosic]

We will try to add this capability in nearest build.

Thanks, I and many other users we go to be waiting anxious.

Eduardo S Santos. 19-01-06

when new build goes this available for Download?

it is my impression or version 3.55 is more faster than version 4.00?

[Ikar]

>when new build goes this available for Download?
The new build will be available for Download in the end of this week or in the beginning of the next one.

>it is my impression or version 3.55 is more faster than version 4.00?
If you know any other losses of productivity in MyDAC 4.00, send us please one example that shows it. We will analyze it and try to find and fix bugs.

[eduardosic]

>when new build goes this available for Download?
The new build will be available for Download in the end of this week or in the beginning of the next one.

>it is my impression or version 3.55 is more faster than version 4.00?
If you know any other losses of productivity in MyDAC 4.00, send us please one example that shows it. We will analyze it and try to find and fix bugs.

I can't send an example because he would have that to also send a table with certe of 200.000 rows. exists two problems:
1 - with the property fetchAll = false the query delay to be closed.
2 - in version 3.55 one "select Nome From customer where Name like ' Eduardo silva% ' is returned more fast than in version 4.00,
this with great tables with more than 150.000 rows, this table is InnoDB.

I am waiting new build of mydac, thanks.

[Ikar]

We have tested performance of MyDAC 4.00.2.8 and 3.55.0.24 versions and haven't noticed any significant difference. Please send us (mydac*crlab*com) a complete small sample to demonstrate it and include script to create table and a procedure that generates and puts data into the table. Also supply us following information
- Exact version of Delphi.
- Exact versions of both MyDACs. You can see it in About sheet of TMyConnectionEditor.
- Exact version of MySQL server and MySQL client.
You can see it in Info sheet of TMyConnection Editor.

[eduardosic]

We have tested performance of MyDAC 4.00.2.8 and 3.55.0.24 versions and haven't noticed any significant difference. Please send us (mydac*crlab*com) a complete small sample to demonstrate it and include script to create table and a procedure that generates and puts data into the table. Also supply us following information
- Exact version of Delphi.
- Exact versions of both MyDACs. You can see it in About sheet of TMyConnectionEditor.
- Exact version of MySQL server and MySQL client.
You can see it in Info sheet of TMyConnection Editor.

Hello, I send a complete example for its email, wait reply.

[Ikar]

Thanks for good example. We have used it for testing our MyDAC versions. So, closing dataset in 4.30 version is as quick as in version 3.55 if FetchAll = False.
Feel free to contact us if you have any further problems.