dotconnect MySQL Professional + Entity Framework + LINQ terrible performance issues

dotconnect MySQL Professional + Entity Framework + LINQ terrible performance issues

Postby szaheer » Mon 13 Oct 2014 15:07

I am using "Devart dotconnect MySQL Professional (8.1.45.0)" as a Connector with LINQ to entities, and I frequently get terrible query performance issues because the entity framework generates queries that use derived tables.
It does work well with "MS-SQL Server 2008 R2" + Entity Framework + LINQ combination.
It started happening when the Project's Database was migrated from "MS-SQL Server 2008 R2" to "MySql Server 5.6".

With the combination of:
"MySql Server 5.6" + Entity Framework + LINQ
the performance of Queries has gone terribly down & some queries do get timed out frequently.
I have tried the above combination with Entity Framework 4.0, 5.0 & 6.0 but nothing seem to fix it.

Please suggest where I am wrong or any solution to get it fixed.

Thanks,
Zaheer
szaheer
 
Posts: 2
Joined: Mon 29 Sep 2014 09:52

Re: dotconnect MySQL Professional + Entity Framework + LINQ terrible performance issues

Postby Shalex » Tue 14 Oct 2014 12:10

1. Please analyze your current approach. Turn on the dbMonitor tool (download link, documentation) and check the generated queries which take much time to execute. Pay attention to the datatypes of parameters, indices in target tables, etc. Try to localize the reason of the performance issue in your scenario.

2. Have you tried to employ pre-generated views for increasing performance?
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL