Highlighted

Populating 100K rows in Advanced Data Grid from LCDS

rgaurava

21-08-2009

I have an Oracle database with 100K rows that I need to populate a AdvancedDataGrid. I have setup my RemoteObject to point to an destination which invokes a java class to return the values. The Java class makes the jdbc connection and creates a List of Maps and retuns the value back.

The problem I am facing is that the code throws an "out of memory" after 2K of data. Any idea on what parameters to configure or is there a better way to do this?

Thanks,

rgaurava

List list =

new ArrayList();

Map testResult;

while (rs.next()) {

testResult =

new HashMap();

testResult.put(

"STRING1", rs.getString("STRING1"));

testResult.put(

"STRING2", rs.getString("STRING2"));

testResult.put(

"STRING3", rs.getString("STRING3"));

list.add(testResult);

}

return

list;

Replies

Highlighted

Michael_Chaize

Employee

25-08-2009

You should try to setup a Data Management architecture.

The tag <mx:DataServices> will help you to activate data-paging and handle your memory issue.