Populating 100K rows in Advanced Data Grid from LCDS

Avatar

Avatar
Level 1
rgaurava
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
rgaurava
Level 1

Likes

0 likes

Total Posts

4 posts

Correct reply

0 solutions
View profile
rgaurava
Level 1

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

Avatar

Avatar
Give Back 10
Employee
Michael_Chaize
Employee

Like

1 like

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Validate 1
View profile

Avatar
Give Back 10
Employee
Michael_Chaize
Employee

Like

1 like

Total Posts

16 posts

Correct reply

0 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Validate 1
View profile
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.