Performance issues with version 3.2.x

dilbert · Post by **dilbert** » Wed 04 Apr 2012 15:30

I encountered performance problems after upgrading dotConnect for Mysql to versions 6.80.x. (I have tried both 6.80.325 and 6.80.332).
It is apparent on complex linq queries (nested etc.), so it's quite hard to debug.

However, sql generated remains still the same and according to DB monitor it executes still very fast. There is no problem with sql but with constructing queries.

For example, time spent on a query
- with version 6.70.302.0 - Elapsed: 00:00:00.0778889 (Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.1.34.0)
- with version 6.80.332.0 - Elapsed: 00:00:02.4041109 (Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.2.64.0)

I haven't posted a specific query because it is really very complex. At first, I'd like to ask if there was any fundamental changes in the compilation of queries or in handling of compiled query cache.

Thanks for your attention.

MariiaI · Post by **MariiaI** » Fri 06 Apr 2012 08:06

Thank you for your report. We have reproduced the issue with performance. We will investigate it and notify you about the results as soon as possible.

StanislavK · Post by **StanislavK** » Fri 06 Apr 2012 14:12

We have fixed the performance issue. The fix will be available in the nearest build, which we plan to release next week.

MariiaI · Post by **MariiaI** » Fri 13 Apr 2012 08:25

New build of dotConnect for MySQL 6.80.341 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area
(for users with active subscription only).

For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23887.