Pagination

[walker1234Participant]

I would like to know how the pagination works in jQWidgets. Basically, if I have a webservice returning json data of 30,000 records, does jQWidget caches all the records at once? I mean if we go by the following example mentioned in the link below:

$('#grid').jqxGrid({ pagesizeoptions: ['10', '20', '30']});

https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-paging.htm

It will only display 10 records in the first view and when a user clicks on the arrow option towards right , it will show another 10 records etc. On the Web developer tools, I don’t see webservice getting called after clicking next /right arrow to view new records.Hence I want to know whether there’s any internal cache mechanism used in jQWidget which can store all the 30,000 records or more as soon as webservice returns it?

[StanislavParticipant]

Hello walker1234,

For using this many records, I would suggest you to use the virtual paging. When you open a new page(click on the nex/right arrow) it will call the data from the server to fill the page, it is faster.

It has a demo on your webpage: Virtual Paging.

Best Regards,
Stanislav

jQWidgets Team
http://www.jqwidgets.com/

[walker1234Participant]

Yes, I am using the same thing. The way it works at my end is a soon as the page loads where my widget is present, a webservice is called and it gets all the records and then I can click on the next/right arrow and it works fine without any delay. This makes me think if all the records are cached behind the scenes by the widget?

As you have mentioned that when we click on next/right arrow it will call the data from the server but in my case, as I have mentioned, the webservice is called only once when the page where the widget is present loads. So, this is kind of contradicting with what you are saying or did I understand something wrong? Please clarify.

Thanks

[StanislavParticipant]

Hello walker1234,

I would suggest you to take a look at this help topics. Link
Especially the Server Side Paging with jqxGrid using PHP and MySQL. I think that will help you with your work as well as all of the other topics there, if you are working with server-side data.

Best Regards,
Stanislav

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts