RepoDB icon indicating copy to clipboard operation
RepoDB copied to clipboard

Use FETCH NEXT over CTE ROW_NUMBER() when doing a BatchQuery.

Open mikependon opened this issue 6 years ago • 1 comments

Use this query instead.

SELECT *
FROM Table
ORDER BY Column1, Column2
OFFSET 13000000
ROWS FETCH NEXT 1000000 ROWS ONLY;

This must only affect the following classes.

  • https://github.com/mikependon/RepoDb/blob/master/RepoDb/RepoDb/_SqlServer/StatementBuilders/SqlServerStatementBuilder.cs
  • And all UnitTests

Note: Integration Tests must run as it is now.

mikependon avatar Aug 05 '19 14:08 mikependon

Done in #1124

ngardon avatar Dec 26 '22 09:12 ngardon