JQxGrid – Virtual mode filter issue

[ShinelinParticipant]

Hi,

I m using JQxGrid with virtualmode enabled with Paging and Filters (Browser :IE8). Have kept both Paging and Filter logic on server side, that works based the url parameters sent by JQxGrid on user interaction.

Experiencing browser hang issue for couple of minutes when the grid component tries to load the filtered data. I see this issue especially when i try to apply filters in more than one column. I dont see any issue with paging.

Can someone please throw some light on this, on what could be probable issue. Is there a way I could tune this?

[Peter StoevKeymaster]

Hi Shinelin,

Unfortunately, from the provided information we will not be able to help much. How do you initialize the Grid? What kind of columns and filters do you use? How do you apply filters in the Grid and how do you implement the server filtering?

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[ShinelinParticipant]

Hi Peter,

Here is more about my code i m using.

function createDataGrid(dataAdapter, datafields, theme)
{
$(“#jqxgrid”).jqxGrid({
width: 1000,
height:640,
source: dataAdapter,
theme: theme,
showfilterrow: true,
filterable: true,
showfiltercolumnbackground: false,
groupable: true,
pageable: true,
pagesize: 50,
virtualmode: true,
rendergridrows: function (params) {
return dataAdapter.records; //processed records from server.
},
sortable: true,
altrows: true,
pagesizeoptions: [’50’, ‘100’, ‘500’, ‘1000’],
columns: columns,
columnsresize: true,
columnsreorder: true

});
}

“return dataAdapter.records; ” – has only the processed records, the records that matched the Filter criteria.

On debugging I observed that the “rendergridrows” receives the result records pretty quickly, then the gridd seems to do a lot of processing to show the filtered records, which ends up hanging my browser.
(even filtered recrods are very few)

On the other hand when navigating between pages, this issue doesn’t occur.

The dataset i m dealing with 20 columns and 1500 records, with 50 records per page.

[Peter StoevKeymaster]

Hi Shinelin,

I am still not sure what could be the issue on your side and we cannot help much with that information. I suggest you to look how the server paging and filtering should be implemented – http://www.jqwidgets.com/jquery-widgets-demo/demos/php/serverfiltering_paging_and_sorting.htm?arctic and also to check out whether you use the latest version – ver. 3.0.3.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[ShinelinParticipant]

Thanks a lot Peter. It really helped, the performance is much better. Did some testing with 200K records, works like a charm.

[Author]

Posts