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

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

Postby eduardosic » Fri 13 Jan 2006 04:05

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.
eduardosic
 
Posts: 387
Joined: Fri 18 Nov 2005 00:26
Location: Brazil

Slow close quer with Fetchall=false

Postby Sedma » Fri 13 Jan 2006 10:03

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
Sedma
 
Posts: 3
Joined: Thu 12 Jan 2006 04:01

Postby Ikar » Mon 16 Jan 2006 10:07

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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

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

Postby eduardosic » Mon 16 Jan 2006 20:05

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.
eduardosic
 
Posts: 387
Joined: Fri 18 Nov 2005 00:26
Location: Brazil

Postby Ikar » Tue 17 Jan 2006 09:32

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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

my Problem continue..

Postby eduardosic » Tue 17 Jan 2006 11:02

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.
eduardosic
 
Posts: 387
Joined: Fri 18 Nov 2005 00:26
Location: Brazil

Postby Ikar » Tue 17 Jan 2006 15:02

We will add fast close for FetchAll = False mode in next MyDAC version.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Thanks Ikar.

Postby eduardosic » Tue 17 Jan 2006 15:54

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?
eduardosic
 
Posts: 387
Joined: Fri 18 Nov 2005 00:26
Location: Brazil

Very slow at closing a query with fetchall = false

Postby rodoarias » Wed 18 Jan 2006 00:58

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
rodoarias
 
Posts: 1
Joined: Wed 17 Nov 2004 20:32
Location: Cali, Colombia

Postby Ikar » Wed 18 Jan 2006 07:29

This capability will be available not in nearest build (4.30.0.10) but in next
MyDAC version (4.50 or 5.0)
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

how time ???

Postby eduardosic » Wed 18 Jan 2006 15:11

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.
eduardosic
 
Posts: 387
Joined: Fri 18 Nov 2005 00:26
Location: Brazil

slow close

Postby Sedma » Wed 18 Jan 2006 19:37

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.
Sedma
 
Posts: 3
Joined: Thu 12 Jan 2006 04:01

Re: slow close

Postby eduardosic » Wed 18 Jan 2006 19:48

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.
eduardosic
 
Posts: 387
Joined: Fri 18 Nov 2005 00:26
Location: Brazil

Re: slow close

Postby eduardosic » Thu 19 Jan 2006 14:40

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. <<<<<
eduardosic
 
Posts: 387
Joined: Fri 18 Nov 2005 00:26
Location: Brazil

Postby Ikar » Thu 19 Jan 2006 16:20

We will try to add this capability in nearest build.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Next

Return to MySQL Data Access Components