loading more than 50,000 records

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

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.

Thank you for reply.

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

Thank you in advance.

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.