Hi folks!

I'm working on a very large scale ASP.NET business application, which has hundreds of grids. I'm comfortable using jqGrid, but here is a critical problem. Since our client's database tables has millions of records, in our search query, we cannot say “select count(*) from table”, as count(*) has a negative impact on performance. This is a strict “no”. But without fetching count of total rows, grid's pagination will not work. The logic for enabling/disabling the “next” and “previous” buttons is tightly coupled with count of total rows inside grid.base.js file.

Can anyone suggest what should be done in my case? How about adding a toolbar with custom pagination? I'm not sure if that takes lot of effort. Please provide your valuable suggestions.

Regards,

Krishna,

http://www.novogeek.com