Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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
Validate 1
Employee
Michael_Chaize
Employee

Like

1 like

Total Posts

16 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Employee
Michael_Chaize
Employee

Like

1 like

Total Posts

16 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 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.