Bug #61754 ADO.NET entity framework context query very slow after 6.3.6 -> 6.3.7 update

• Submitted: 5 Jul 2011 15:39
• Modified: 11 Aug 2011 11:08
• Reporter: Roberto Zanin
• Status: No Feedback
• Category: Connector / NET
• Severity: S5 (Performance)
• Version: MySql Connector 6.3.7
• OS: Windows (Vista and XP 32 bit)
• Assigned to: Bogdan Degtyariov
• CPU Architecture: Any
• Tags: ADO.NET, connector .net 6.3.7, EF, entity framework, very slow

[5 Jul 2011 15:39] Roberto Zanin

Description:
Few days ago I updated a release of my software and I included in it the new version of MySql.Data.dll and MySql.Data.Entity.dll (6.3.7). 

Today I have realized that my software is very slow, more than 10 seconds to retrieve data by the EF context and fill a datagridview.

At first I was thinking to a server problem and I checked the number of connections, the server cpu and memory load but was all ok.

Also I tried to come back to the old .dll version (6.3.6) and "WOW!" now less than a second to load data and fill the grid.

How to repeat:
I don't know if the problem is repeatable... I simply update the connector and I recompiled my software with the new .dll and after the released the update my software became very slow on all PCs (all with WinXP) during the excecution of the calls to the EF context.

Suggested fix:
Come back to version 6.3.6

[11 Jul 2011 11:08] Bogdan Degtyariov

Roberto,

Thanks for your feedback.
Please let us know when you have updates and/or repeatable test case for it.

[11 Aug 2011 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".