Find out, why dataset uses so long

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Find out, why dataset uses so long

Post by Zero-G. » Wed 07 Mar 2007 10:21

Hey

I am using v. 3.5

How can I find out, why retriving data through a dataset uses such a long time.

I have created a dataset, with the dataset Designer. - The SQL Statement is not very complicated & when I use the code in the mySQLControlCenter, it takes 0,08 sec to give back the information. - But when I use the dataset, it takes up to 8 sec.

How can I find out, what the problem is?

Second question: - When will the finished v4 be available?

THX

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 07 Mar 2007 11:22

I suppose the time is consumed for opening a connection to MySQL server.

Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Post by Zero-G. » Wed 07 Mar 2007 11:29

Hey

But I do use more datasets (designed through the designer) - And there it works really fine.

No idea for the second question?

THX

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 07 Mar 2007 11:47

But I do use more datasets (designed through the designer) - And there it works really fine.
You mean you have many datasets and only one of them works so slow? Maybe it is connected with connection pooling.
No idea for the second question?
We are going to release MySQLDirect .NET 4.0 in two weeks.

Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Post by Zero-G. » Wed 07 Mar 2007 12:04

You mean you have many datasets and only one of them works so slow? Maybe it is connected with connection pooling.
Yes, that is correct - How do I turn off connection pooling in a designed DataSet?
We are going to release MySQLDirect .NET 4.0 in two weeks
Will the registered users be informed by mail? - Because I would like to know, when the new version is out!

THX

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 07 Mar 2007 12:56

How do I turn off connection pooling in a designed DataSet?
I cannot say for sure that the problem is in pooling. Please describe in detail how you use datasets. You may send me small test project to reproduce the problem. Include definitions of your own database objects. Use e-mail address provided in the Readme file.
Will the registered users be informed by mail?
Yes, you will be notified via e-mail.

Post Reply