Entity Framework Skip/Take is very slow when number to skip is big

by

You are right on that, Skip().Take() approach is slow on SQL server. When I noticed that I used another approach and it worked good. Instead of using Linq Skip().Take() – which writes the code you showed – , I explicitly write the SQL as:

select top NTake ... from ... order by ... where orderedByValue > lastRetrievedValue

this one works fast (considering I have index on the ordered by column(s)).

More Related Contents:

  1. query sql between two tables [duplicate]
  2. How does database indexing work? [closed]
  3. What is the best way to paginate results in SQL Server
  4. Best way to select random rows PostgreSQL
  5. Best way to test if a row exists in a MySQL table
  6. Condition within JOIN or WHERE
  7. Subqueries vs joins
  8. Where is |DataDirectory| defined?
  9. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  10. SQL ‘like’ vs ‘=’ performance
  11. How many rows in a database are TOO MANY?
  12. LINQ to SQL multiple tables left outer join
  13. How can you handle an IN sub-query with LINQ to SQL?
  14. Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
  15. How do I use structural annotations to set SQL type to Date in model first approach
  16. Is a JOIN faster than a WHERE?
  17. What’s the best to check if item exist or not: Select Count(ID)OR Exist(…)?
  18. Fastest way to determine if record exists
  19. SQL count(*) performance
  20. Why is a UDF so much slower than a subquery?
  21. SQL performance: WHERE vs WHERE(ROW_NUMBER)
  22. Subquery v/s inner join in sql server
  23. Join and Include in Entity Framework
  24. SQL Server SELECT LAST N Rows
  25. Improving performance of cluster index GUID primary key
  26. When using GETDATE() in many places, is it better to use a variable?
  27. How do you interpret a query’s explain plan?
  28. IN vs OR of Oracle, which faster?
  29. Oracle , != , ^= operators
  30. sql query joins multiple tables – too slow (8 tables)

Leave a Comment