score:3
After looking at the sample execution time, that you have provided, it looks like the time is increasing linearly (150 -> 200 -> ... -> 1005 -> 1700) as you open more number of pages. So by the time, you reach page15, the query has to process more number of records, to fetch the data corresponding to page 15. My guess is its not the problem with page 15th but overall the query itself is taking time as the number of records increases. You can try to optimize the query by tuning the indexes of the tables.
Source: stackoverflow.com
Related Query
- LINQ2SQL select orders and skip/take
- LINQ with Skip and Take
- LINQ query adding orderby makes Skip and Take not work Linqpad
- Casting result of Dictionary of objects after Skip and Take
- LINQ, Skip and Take ordering
- OrderByDescending with Skip and Take in LINQ shows error
- LINQ How to take one record and skip rest c#
- Getting COUNT and SKIP TAKE in one operation with Linq to Entities
- Using Skip and Take to pick up alternate items in an array
- LINQ to Entities Skip and Take
- Are Linq's Skip and Take optimized for arrays? [4.0 edition]
- Avoid extra loop and could not find implementation of query pattern for source type int Select not found
- Skip and Take option for java arraylist?
- IOrderedQueryable Skip and Take
- LINQ: Paging technique, using take and skip but need total records also - how to implement this?
- Most recent records with 2 tables and take / skip
- Is it possible to use Skip and Take whilst calculating an Average?
- How can I run a paged query in EF Core if Skip and Take are always evaluated locally?
- LINQ IQueryable returning same rows with skip and take
- how does skip and take really work?
- LINQ to SQL - order by, group by and order by each group with skip and take
- LINQ: Skip and Take duplicates
- Linq to Entities - Internal Behavior of Skip and Take
- Skip and take method in List
- how to apply Skip and Take on Include
- Skip and Take is generating exception in Entity Framework
- Entity Framework Skip and Take didn't translated to SQL command
- How to call Expression<Func<T, bool>> parameterized function wtih Linq Skip and Take
- LINQ - Order By and Distinct by different fields. Skip & Take distinct values
- Performance of Skip and Take in Linq to Objects
More Query from same tag
- How do I sum a sub-list in linq?
- Linq statement to select common elements between two collections
- C # Linq equivalent of SQL nested group by
- How to Filter linq query
- what is output type of method when returns result of linq query?
- LINQ NHibernate, latest related entity
- WPF: How do I validate that a number from memory is not duplicated in db table?
- Linq query using join
- Select a Dictionary<T1, T2> with LINQ
- Depth-first flattened collection of an object hierarchy using LINQ
- Getting names of properties in JSON.NET with C#
- Does Linq/.NET3.5 support a 'zip' method?
- LINQ to Entities .contains is ignoring results with NULL
- Join a list with an entity and get the average from the second table
- LINQ (Or pseudocode) to group items by proximity
- Extension methods not showing even on implementing IEnumerable
- How to write LINQ query on Generic List
- Collect indexes from list
- How to add condition in linq lambda expression
- Can we make this more terse with linq?
- Using LINQ in an Update Method - trouble with where clause
- List<>.Exists() doesn't exist in WP7?
- Generic Select clause in Linq
- Populate a Datagrid with a Linq query
- Simple update with Entity Framework
- LINQ OrderBy and StringBuilder
- How to get grouped array of fields from DataTable with LINQ
- Linq with entity Framework using a function to select columns
- Enumerable.Aggregate error
- Distinct IEqualityComparer<> problems
