----- Original Message ----- From: "letterpigeon" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, November 09, 2007 7:03 PM Subject: [flexcoders] Flex grid to serve 100K-1mil rows
> 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. Imagine sitting using this application and scrolling through 3K rows. You'll be there awhile. Now imagine scrolling through 100K rows. No user will do that. My suggestion would be to implement filters for the data and use those to reduce the traffic to the client by filtering on the server. Implement your current search and replace on the server and refresh the (now reduced data) on the client. If you have to have large datasets, a pagination algorithm and caching is probably the way to go. Paul > > Regards, > Ban
