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

[eduardosic]

Helo, i use mydac 4.00.2.8, but when close a big query is very Slow!

for open is very Fast but on close is very very slow.


when the release fixing the serius bug is ok for Download?

is very important.

[Sedma]

I have the same problem with Delphi 7 and newest MyDac 4.00.2.8.
MySQL 5.0.18, engine MYISAM

I have query with over 10^6 records, FetchAll = False, connect, open, close, disconnect.

Connect and open very quick, close freeze for aprox. 20 seconds. No difference when Direct is true or false.

Is there something I do wrong ?

Thanks,

Martin

[Ikar]

If FetchAll option is disabled, you don't get all the data immediately, but server can't close connection until all the requested data is transferred. To avoid this behaviour you can kill the session using another connection if you really need it.

[eduardosic]

If FetchAll option is disabled, you don't get all the data immediately, but server can't close connection until all the requested data is transferred. To avoid this behaviour you can kill the session using another connection if you really need it.

I want to know because this bug not happened with version 3.55 for example? until version 4.00.1.6 this did not happen I needs to know when this bug goes to be corrected?

This problem occurs with FetchAll = True or False

my SQL Queries had been very slow for cause of this.

Bug description :

TmyQuery > FetchAll = False
SQL > select Name, cod, CPF from clients where name like 'jose da Silva%'
Open; // very Fast
long times with Query open;
Close; // very very very Slow in actual version


please the possible fastest Bug corrects.

[Ikar]

In old MyDAC versions this behavior caused memory and resource leak. After users' requests we fixed the problem, but as result MyDAC has slowdown at closing underfetched datasets.

[eduardosic]

In old MyDAC versions this behavior caused memory and resource leak. After users' requests we fixed the problem, but as result MyDAC has slowdown at closing underfetched datasets.

it would be interesting to keep as in the previous version, therefore the majority of the users uses FetchAll = False searchs it to be more fast, or then you it could create a FastCloseOnFetchAllFalse property, to be able to take care of to all, where if the property will be true it uses the solution of the previous version and it will be False, it uses code current.

please, Fix the problem, my application is very Slow.

[Ikar]

We will add fast close for FetchAll = False mode in next MyDAC version.

[eduardosic]

We will add fast close for FetchAll = False mode in next MyDAC version.

Thanks for help. this resource you go to place in next release? example 4.00.2.9? when it goes to be available?

[rodoarias]

I have a problem with Delphi 5 and MyDac 4.00.2.8.
MySQL 4.1.16, engine MYISAM. When closing a query.
I open the query and then close it, inmediatly, but when close is very slow.
before at version MyDac 4.00.1.6 is fine.

Excuse my bad english

[Ikar]

This capability will be available not in nearest build (4.30.0.10) but in next
MyDAC version (4.50 or 5.0)

[eduardosic]

This capability will be available not in nearest build (4.30.0.10) but in next
MyDAC version (4.50 or 5.0)

Ikar, in we go them to be with softwares slow until the next version 4.50 or 5? how much time goes to take? 6 months 1 year? please, this resource already existed in version 3.55 and is very important, please, places it in next Build of the component, is very important.

cannot wait until the next version to the component, my customers are complaining of the performance of the system, and exactly for being fast that I bought the package myDAC.

excuse for my the bad English.

[Sedma]

I installed this trial version and tested, but it seems to be not usable with fetchall = false, because this is what I needed -> performance for big queries. So I uninstalled and will use another library, maybe I will come back in future when it will be fixed.

[eduardosic]

I installed this trial version and tested, but it seems to be not usable with fetchall = false, because this is what I needed -> performance for big queries. So I uninstalled and will use another library, maybe I will come back in future when it will be fixed.

this is a great problem, mydac is better that any another package of components exactly for the performance with FetchAll = False, unhappyly without this correction is complicated, Ikar please, makes one fix to add a Fast Close with fetcheAll = false, as well as was in version 3.55, thus does not have to be so dificult! is an necessity of who bought the component and of who still it goes to buy.

[eduardosic]

I installed this trial version and tested, but it seems to be not usable with fetchall = false, because this is what I needed -> performance for big queries. So I uninstalled and will use another library, maybe I will come back in future when it will be fixed.

this is a great problem, mydac is better that any another package of components exactly for the performance with FetchAll = False, unhappyly without this correction is complicated, Ikar please, makes one fix to add a Fast Close with fetcheAll = false, as well as was in version 3.55, thus does not have to be so dificult! is an necessity of who bought the component and of who still it goes to buy.

>>>> waiting reply of the Core lab. <<<<<

[Ikar]

We will try to add this capability in nearest build.