Page 1 of 2

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

Posted: Fri 13 Jan 2006 04:05
by 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.

Slow close quer with Fetchall=false

Posted: Fri 13 Jan 2006 10:03
by 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

Posted: Mon 16 Jan 2006 10:07
by 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.

This is one bug and not problem of transference of the data.

Posted: Mon 16 Jan 2006 20:05
by eduardosic
Ikar wrote: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.

Posted: Tue 17 Jan 2006 09:32
by 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.

my Problem continue..

Posted: Tue 17 Jan 2006 11:02
by eduardosic
Ikar wrote: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.

Posted: Tue 17 Jan 2006 15:02
by Ikar
We will add fast close for FetchAll = False mode in next MyDAC version.

Thanks Ikar.

Posted: Tue 17 Jan 2006 15:54
by eduardosic
Ikar wrote: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?

Very slow at closing a query with fetchall = false

Posted: Wed 18 Jan 2006 00:58
by 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

Posted: Wed 18 Jan 2006 07:29
by Ikar
This capability will be available not in nearest build (4.30.0.10) but in next
MyDAC version (4.50 or 5.0)

how time ???

Posted: Wed 18 Jan 2006 15:11
by eduardosic
Ikar wrote: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.

slow close

Posted: Wed 18 Jan 2006 19:37
by 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.

Re: slow close

Posted: Wed 18 Jan 2006 19:48
by eduardosic
Sedma wrote: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.

Re: slow close

Posted: Thu 19 Jan 2006 14:40
by eduardosic
eduardosic wrote:
Sedma wrote: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. <<<<<

Posted: Thu 19 Jan 2006 16:20
by Ikar
We will try to add this capability in nearest build.