Hi Marin,

Thank you. I'm looking forward to the next release.

Regards,

Wietze

Hi Marin,

Thanks for your answer, but I disagree. The nice thing about Blazor Server is that you can provide an IQueryable as the datasource and the grid handles all the data retreival and paging etc. If you were right, how would you explain the difference between version 2.7.0 (and previous) and 2.7.1? If I use 2.7.0 I get two queries (count and top <pagelength>). If I use 2.7.1 without changing anything else, I get an extra query that gets all the records. If you've got 100.000 plus records, like I somtimes get in my application, the performance takes a big hit.

The standard FetchData page has no paging and does a foreach over the datasource, so the queries it produces are different.

Regards,

Wietze

Hi Marin,

Included you find an example that uses SQL Server. After creating the database, you have to add some records manually.

What I found is that in version 2.7.0 two queries are executed initially:

SELECT COUNT(*)
FROM [WeatherForecasts] AS [w]

SELECT [w].[ID], [w].[Date], [w].[Summary], [w].[TemperatureC]
FROM [WeatherForecasts] AS [w]
ORDER BY (SELECT 1)
OFFSET @__p_0 ROWS FETCH NEXT @__p_1 ROWS ONLY

In version 2.7.1 this query is executed before these queries:

SELECT [w].[ID], [w].[Date], [w].[Summary], [w].[TemperatureC]
FROM [WeatherForecasts] AS [w]

This query fetches all records and with many records that can take a while. When selecting a different page this query is not repeated.

Regards,
Wietze