loading more than 50,000 records

Suite and Optimus Suite 5
#1

I want to load more than 50,000 records so Am rendering the grid with XML from server side create using php code as follows
$sql.= " LIMIT “.$posStart.”,".$count;
$res = mysql_query ($sql);
print("");
if($res){
while($row=mysql_fetch_array($res)){
print("<row id=’".$row[‘item_id’]."’>");
print("");
print($row[‘item_nm’]);//."[".$row[‘item_id’]."]");
print("");
print("");
print(“index is “.$posStart);
print(””);
print("");
print($row[‘item_cd’]);
print("");
print("");
$posStart++;
}
}
print("");
the problems it has error on the browser as follows
TypeError: row is undefined
[Break On This Error]

…his._c_order)ind=this._c_order[ind];return row._locator.call(this, row.data, ind…
help please

#2

Please beware that in case of dynamic loading - you can’t use client side sorting or client side filtering. Only server side filtering and sorting can be used.

Above error can occurs when you are using client side sorting|filtering against not fully loaded grid.

#3

Thank you for reply.

Which is the best way to load 50,000 records. with clients side filtering and sorting

Thank you in advance.

#4

You can try to use static smart rendering - but 50 000 rows is quite big set of data.
For such big sets of data dynamic loading and server side filtering will work much better.