Grid With pageing but without count

Hey there, I am using Odata in my grid. 
For paging grid hasto know Total count and calculate page count etc. I understand this.

I am progfiling database . There is count queryies which slows down performance.

Are there such an option which doesnt show "Page count" - "record Count" etc but dows side of grid there will be only
"<<Previous", "Next>>"

I have tried vistualisation there is still "count queries".
Thanks.


3 Replies

PS Prathap Senthil Syncfusion Team December 4, 2023 01:39 PM UTC

Hi,

We have analyzed your query and we suggest you use the Pager template of SfGrid. We have already discussed this topic in our UG documentation. Kindly refer to the shared links for your reference.


Reference links: https://blazor.syncfusion.com/documentation/datagrid/paging#pager-template      


Regards,

Prathap S



BL Blazor December 7, 2023 01:24 PM UTC

It's still reletaed with total count in soruce code.;
https://blazor.syncfusion.com/demos/datagrid/pager-template

Anyway maybe what i want is not a fancy idea. 

I just dont want double query(One for count , one for the real query) for performance.
When you have '&$count=true ' in query, odata multiplies database request. You can profile it.


Thakns for interest.



PS Prathap Senthil Syncfusion Team December 13, 2023 03:15 AM UTC

We would like to clarify that it is not feasible to do without datasource count using the paging and virtualization features in the grid. This is the default behavior.


Loader.
Up arrow icon