jQWidgets Forums

jQuery UI Widgets Forums Grid JQxGrid – Virtual mode filter issue

Tagged: 

This topic contains 4 replies, has 2 voices, and was last updated by  Shinelin 11 years, 5 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
  • JQxGrid – Virtual mode filter issue #30674

    Shinelin
    Participant

    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?

    JQxGrid – Virtual mode filter issue #30675

    Peter Stoev
    Keymaster

    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

    JQxGrid – Virtual mode filter issue #30708

    Shinelin
    Participant

    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.

    JQxGrid – Virtual mode filter issue #30715

    Peter Stoev
    Keymaster

    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

    JQxGrid – Virtual mode filter issue #30838

    Shinelin
    Participant

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

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.