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

ok...

Postby eduardosic » Thu 19 Jan 2006 19:08

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

Re: ok...

Postby eduardosic » Sat 21 Jan 2006 16:23

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

Postby Ikar » Mon 23 Jan 2006 15:12

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

Postby eduardosic » Tue 24 Jan 2006 21:51

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

Postby Ikar » Thu 26 Jan 2006 12:21

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

OK, i Send..

Postby eduardosic » Thu 26 Jan 2006 16:01

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

Postby Ikar » Tue 31 Jan 2006 07:40

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

Previous

Return to MySQL Data Access Components