CODEWITHSUNDEEP
ajaxjquery-pluginsjqgrid
Moses
Moses

Reputation: 327

How to use jqgrid when your resultset size is too large to compute?

I'm attempting to use jqgrid. Unfortunately, I can't compute a resultset size because I'm using a very large database and computing the size of the resultsets I'm providing is very slow. I can get data reasonably quickly, but getting a count of the resultset for my queries just isn't possible.

Is there a way to get around this? Perhaps by not using a pager, but instead using some kind of scrollbar? Is there any kind of standard technique that's being used by people out there to get around this? I looked at the virtual scrollbar and autoloading data while scrolling examples, but they both seem to require a total.

I really want to use jqGrid. I actually already have an implementation in one of my code branches that uses it, but its computing resultset sizes using a much smaller database. Does anyone have any suggestions on this?

Upvotes: 0

Views: 3312

Answers (3)

Moses
Moses

Reputation: 327

The answer to this question was provided to me by OlegK. You can see his answer here:

http://www.trirand.com/blog/?page_id=393/help/can-you-use-jqgrid-if-you-cannot-provide-a-resultset-size/

Upvotes: 1

Hoodwink
Hoodwink

Reputation: 1

You could implement paging, and just retrieve data for the current page. I have implemented something similar where I had to retrieve 30,00o rows and it works great!

Upvotes: 0

Lorenzo
Lorenzo

Reputation: 29427

Give a look to the True scrolling Rows sample.

It's under New in version 3.6 => True scrolling Rows

Upvotes: 1

Related Questions