BTW, according to my personal experience flash player unable to handle
more that 10K records in data grid.
Just physically unable - out of memory error!
I have no problem populating a DataGrid with one million records. The
following program takes 519 MB when I run it on my Windows machine,
which has 2 GB of RAM. With no records it takes 73 MB, so each record
requires about 450 bytes of memory for the 6 String fields.
- Gordon
?xml version=1.0 encoding=utf-8?
mx:Application xmlns:mx=http://www.adobe.com/2006/mxml
http://www.adobe.com/2006/mxml
initialize=initializeHandler(event)
mx:Script
![CDATA[
import Person;
private function initializeHandler(event:Event):void
{
const N:int = 100;
var a:Array = new Array(N);
for (var i:int = 0; i N; i++)
{
var p:Person = new Person();
p.firstName = FirstName + i;
p.lastName = LirstName + i;
p.address = Address + i;
p.city = City + i;
p.state = State + i;
p.zip = Zip + i;
a[i] = p;
}
dg.dataProvider = a;
}
]]
/mx:Script
mx:DataGrid id=dg
mx:columns
mx:DataGridColumn dataField=firstName/
mx:DataGridColumn dataField=lastName/
mx:DataGridColumn dataField=address/
mx:DataGridColumn dataField=city/
mx:DataGridColumn dataField=state/
mx:DataGridColumn dataField=zip/
/mx:columns
/mx:DataGrid
/mx:Application
-
Person.as:
package
{
public class Person
{
public function Person()
{
super();
}
public var firstName:String;
public var lastName:String;
public var address:String;
public var city:String;
public var state:String;
public var zip:String;
}
}
From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of lytvynyuk
Sent: Friday, November 09, 2007 12:23 PM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Re: Flex grid to serve 100K-1mil rows
BTW, according to my personal experience flash player unable to handle
more that 10K records in data grid. Just physically unable - out of
memory error!
--- In flexcoders@yahoogroups.com mailto:flexcoders%40yahoogroups.com
, letterpigeon [EMAIL PROTECTED] wrote:
Hi all,
We've built a flex grid that supports mass action on its data right
now (column-wise search replace). But it just doesn't scale right
now. It can hold up to around 3K+ rows in the grid, but it's taking a
good few mins to load that up from the java backend servlet. The
requirement is for the grid to be able to support up to 100K+ or even
1 million rows (may be not displaying them all at once, but when the
mass action/search is taken, it should be performed on the complete
dataset, not just what is being served up on the grid).
We're just looking for ideas how this could be achieved, i.e.: if
pagination is needed, what is the best way to do? client side
pagination v.s. server? Could this be a good use case for Flex Data
Service? etc.
Any pointers/ideas/experience would be greatly appreicated. Thanks in
advance.
Regards,
Ban