Issue of slow data loading in Radzen grid in .net 8 blazor web app in both SSR and CSR And Auto mode ? How to Fix this?

Question

Issue of slow data loading in Radzen grid in .net 8 blazor web app in both SSR and CSR And Auto mode ? How to Fix this?

Kuldeep Y 41

Hi,

I have a Razor component and in this component I have Radzen grid to show data , In my data base i have 60000 + rows and I am showing this data to component page using Radzen Datagrid but its taking more then 1 minute to load the data how i can speed it up ?

Anonymous

2024-04-26T09:33:06.0766667+00:00

Hi @Kuldeep Y, Here are some ways you could try:1.You can implement server-side paging. 2. Load data dynamically as the user interacts with the grid, rather than loading all the data upfront. 3. If the data doesn't change frequently, consider caching the data on the server side to avoid fetching it from the database repeatedly. 4.Ensure that your database queries are optimized for performance, with appropriate indexes and query optimizations.

1 answer

Your answer

Anonymous

2024-04-26T09:33:06.0766667+00:00

Hi @Kuldeep Y, Here are some ways you could try:1.You can implement server-side paging. 2. Load data dynamically as the user interacts with the grid, rather than loading all the data upfront. 3. If the data doesn't change frequently, consider caching the data on the server side to avoid fetching it from the database repeatedly. 4.Ensure that your database queries are optimized for performance, with appropriate indexes and query optimizations.

Answer 1

Bruce (SqlWork.com) 77,686 Volunteer Moderator

you use either paging or a virtual grid. I don’t use Radzen, but I believe they call it virtualization.

Share via

Issue of slow data loading in Radzen grid in .net 8 blazor web app in both SSR and CSR And Auto mode ? How to Fix this?

1 answer

Your answer