Ado.net - Optimize Query Generated By Cfado.net Db2 Provider.

  • Thread starter Thread starter Sven Cuypers
  • Start date Start date
Status
Not open for further replies.
S

Sven Cuypers

Guest
Currently "RowNumber" is used for Take() and Skip() with the DB2 Entity Framework Provider. This results in bad performance results. Running the query with "fetch first 100 rows only" instead of using RowNumber in the where clause, results in much better performance.

Continue reading...
 
Status
Not open for further replies.
Back
Top