Grid Filtering Performance

[AA5MCParticipant]

Hello,

I have a zooming chart, that when the user zooms in I am filter a dataGrid based on the start and end dates in the chart.
There are there are 2 columns I’m filter on.

One is the a date and time and the other is a string.
this works but the delay in filtering is taking sometime, I’m assuming because of the amount of data. however, what I would like is to should a wait icon over the chart if possible. I have tried some jquery plugin spinner to indicated waiting. But none seem to work?
is there any built in wait (loading indicators) that I could show when the filtering is happening?

here is my filtering routine in case you wanted to see if I was implementing this correctly. maybe there is a faster way to preform the filtering:

    var filter_or_operator = 0;
    var filtergroup = new $.jqx.filter();

    var filtervalue = fromdate;
    var filtercondition = 'GREATER_THAN_OR_EQUAL';
    var fromFilter = filtergroup.createfilter('datefilter', filtervalue, filtercondition);

    filtervalue = todate;
    filtercondition = 'LESS_THAN_OR_EQUAL';
    var toFilter = filtergroup.createfilter('datefilter', filtervalue, filtercondition);

    var sitegroup = new $.jqx.filter();
    filtervalue = site;
    filtercondition = 'EQUAL';
    var siteFilter = filtergroup.createfilter('stringfilter', filtervalue, filtercondition);
 
    filtergroup.addfilter(filter_or_operator, fromFilter);
    filtergroup.addfilter(filter_or_operator, toFilter);
    sitegroup.addfilter(filter_or_operator, siteFilter);

    $('#jqxgrid').jqxGrid('addfilter', 'timeend', filtergroup, true);
    $('#jqxgrid').jqxGrid('addfilter', 'site', sitegroup, true);

[ivailoParticipant]

Hi AA5MC

Like a workaround you can set a loading image behind the chart and to show that image until is filtering. Just have show the image before to call addfilter or if is detected change event of the filter inputs (then image overlays the chart), and after to detect the filter event (to hide image behind the chart). These events will change only the z-index of the image.

Here you can see similar example. The difference is about triggering with “click” event, but the principle is the same.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts