jQuery Grid Plugin - jqGridForum

Forum

November 2nd, 2014

A A A

Topic RSS

Performence issue with tabletogrid

03/01/2012
12:05

elwood

New Member

Members

Forum Posts: 1

Member Since:
03/01/2012

Offline

Hi there,

I got heavy performance issues with the tabletogrid function. I try to convert a table with 325 records. It takes about 3 seconds to build the html table, but afterwards, when I try to convert it, it takes about 1.5 minutes. Is there a chance to improve the speed? It would be great, if anybody could give me some good advices.

Here is my code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html>

<head>

$(test);

function test(){

$("#selectionTable tr").mouseover(function(){

$(this).addClass("highlight");

}).mouseout(function(){

$(this).removeClass("highlight");

}).click(function(){

$(this).addClass('selected');

$('#gridDIV').empty();

var vTable = $(this).children("td:first").text();

$.post('url…?IBIF_ex=GRDR001T&|V_TABLE='+vTable,function(titles){

$.post('url…?IBIF_ex=GRDR001C&|V_TABLE='+vTable,function(colMod){

$.post('url…?IBIF_ex=GRDR001&|V_TABLE='+vTable,function(data){

$('#gridDIV').transform({async:false,xmlstr:data,xsl:'url…test.xsl',complete:function(html,xsl,xml,transform){

$('#gridDIV').append('<div id="pagerDIV"></div>');

eval(colMod);

eval(titles);

// until here it takes about 2-3 seconds

tableToGrid($('#gridDIVTable'),{

autowidth: true,

ignoreCase: true,

height: '100%',

width: '100%',

pager: '#pagerDIV',

rowNum: 30,

rowList: [10,20,30],

rownumbers: true,

viewrecords: true,

gridview: true,

mtype: 'POST',

editurl: 'url…?IBIF_ex=GRDR001S',

caption: vTable,

colNames: vColNames,

colModel: vColModel

});

// until here about 2 minutes

}});

},'text');

});

}

</script>

</head>

<table>

<tr>

<td>

<tr>

<th>Tables</th>

</tr>

<tr>

<td>Test_table</td>

</tr>

</table>

</td>

<td>

</td>

</tr>

</table>

</body>

</html>

And here are some sample data:

<TBODY>

<TR>

<TH>REPORT</TH>

<TH>SELFILE</TH>

<TH>FILETYPE</TH>

<TH>TEST_VALUE</TH>

<TH>RESULT_VALUE</TH>

</TR>

<TR>

</TR>

<TR>

</TR>

<TR>

</TR>

</TBODY>

</TABLE>

03/01/2012
13:52

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Sure it is possible. You have 3 nested ajax calls - please check these calls how long they are?

As simple as possible please test it without these ajax calls.

Not sure, but I think you should implement ajax queene.

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

01/12/2012
23:13

koenboone

New Member

Members

Forum Posts: 1

Member Since:
02/12/2012

Offline

Not counting the nested ajax calls, I found this 'reworked' tabletogrid function that is a lot faster:

http://s339.codeinspot.com/q/1918992

It does however produces some disadvantages, for example column sorting doesn't seem to work anymore.

But it is surely faster if you only need to display a grid

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
56 Guest(s)