performance in loading grid

[assaf.frank123Participant]

Hi,

I am using jqwidgets2.8.

I see that the grid may take time to load (10+ seconds )

I have many scripts being downloaded and afraid it might be due to large scripts download etc.

1. Can version 2.9+ improve this?
2. Can nested widgets have an affect? (Tab and in one of the tabs a grid).
3. Are the scripts included the proper way or should I be using a minimized version?

4. Is there any unneeded redndering going on on the grid:

$(“#jqxgrid”).jqxGrid(
{
height: 380,
width: ‘99%’,
source: dataAdapter,
showfilterrow: true,
filterable: true,
theme: theme,
selectionmode: ‘multiplecellsextended’,
editable: false,
showstatusbar: true,
statusbarheight: 45,
enabletooltips: true,
columnsresize: true,
showaggregates: true,
sortable: true,
columns: [
{ text: ‘Date’,pinned: true, align:’left’ ,datafield: ‘date’, filtertype: ‘date’, width: 120, cellsalign: ‘left’, cellsformat: ‘dd/MM/yyyy’,aggregates: [‘count’]},
{ text: ‘Day’,pinned: true, align:’left’ ,datafield: ‘day’, filtertype: ‘checkedlist’, width: 70, cellsalign: ‘left’},
{ text: ‘Time’,pinned: true, align:’left’ ,datafield: ‘time’, filtertype: ‘checkedlist’, width: 140, cellsalign: ‘left’},
{ text: ‘KW’,pinned: true,align:’left’ , columntype: ‘textbox’, filtertype: ‘checkedlist’,cellsalign: ‘left’,datafield: ‘kw’, width: 120},
{ text: ‘Ad’,pinned: true,align:’left’ , columntype: ‘textbox’, filtertype: ‘checkedlist’,cellsalign: ‘left’,datafield: ‘ad’, width: 120},
{ text: ‘Page’,pinned: true,align:’left’ , columntype: ‘textbox’, filtertype: ‘checkedlist’,cellsalign: ‘left’, datafield: ‘lp’, width:120,cellsrenderer: linkrenderer },
{ text: ‘Deal’,pinned: true,align:’left’ , columntype: ‘textbox’, filtertype: ‘checkedlist’,cellsalign: ‘left’, datafield: ‘deal’, width: 120},
{ text: ‘Deal Amount’,pinned: true, align:’left’ , datafield: ‘quantity’, filtertype: ‘number’, cellsalign: ‘left’,width: 100 ,columntype:’numberinput’,aggregates: [‘sum’, ‘avg’]},
{ text: ‘Followup Date’, align:’left’ ,datafield: ‘followupdate’, filtertype: ‘date’, columntype: ‘datetimeinput’,width: 150, cellsalign: ‘left’, cellsformat: ‘dd/MM/yyyy’ },
{ text: ‘Account Remarks’,align:’left’ , columntype: ‘textbox’, filtertype: ‘textbox’,cellsalign: ‘left’, filtercondition: ‘contains’, datafield: ‘remarks’, width:200},
{ text: ‘Name’,align:’left’ , columntype: ‘textbox’, filtertype: ‘textbox’,cellsalign: ‘left’, filtercondition: ‘contains’, datafield: ‘name’, width: 150},
{ text: ‘Phone’,align:’left’ , columntype: ‘textbox’, filtertype: ‘textbox’,cellsalign: ‘left’, filtercondition: ‘contains’, datafield: ‘phone’, width: 150},
{ text: ‘Lead Remarks’,align:’left’ , columntype: ‘textbox’, filtertype: ‘textbox’,cellsalign: ‘left’, filtercondition: ‘contains’, datafield: ‘cremarks’, width: 200},
{ text: ‘id’, align:’left’ , columntype: ‘textbox’, filtertype: ‘textbox’,cellsalign: ‘left’, filtercondition: ‘contains’, datafield: ‘id’, width: 200} ,
{ text: ‘vid’, align:’left’ , columntype: ‘textbox’, filtertype: ‘textbox’,cellsalign: ‘left’, filtercondition: ‘contains’, datafield: ‘vid’, width: 200},
{ text: ‘pid’, align:’left’ , columntype: ‘textbox’, filtertype: ‘textbox’,cellsalign: ‘left’, filtercondition: ‘contains’, datafield: ‘pid’, width: 200}
]
});

Thanks very much.

[assaf.frank123Participant]

For number 3 –
I am using the scripts bellow –

[aoverton07Participant]

Are you loading your data via ajax? in w/e browser you’re using take a look at the developer tools, specifically “Network”. If you have a bunch of ajax calls you will see that your ajax call for your grid is probably at the end of the queue. So your grid really only takes 1-2 seconds to load, but has to wait 7-8 seconds until after everything before it has loaded. You can count on getting only 2-4 simultaneous ajax calls.

[Author]

Posts