[flexcoders] Re: Handle Large Dataset

2008-05-07 Thread Alan Gruskoff
Think of it like an Ice Cream Truck. You can't consume 35,000 Ice Creams all at once, so grab an armful at a time and work on those. Since your users' screen will only accommodate 20-100 items at a time, work with 20-100 data items at a time. Find out how your database makes a subset available,

[flexcoders] Re: Handle Large Dataset

2008-05-07 Thread David C. Moody
I found Matt's example and was able to get it working somewhat. But with such a large database, after about the 2nd or third trip to the database, the control gets messed up. Then each time you touch the slider in the down direction it goes back to the database. I think I'll continue to work

[flexcoders] Re: Handle Large Dataset

2008-05-07 Thread David C. Moody
Yeah I was trying to think of how to use the LIMIT statement from Flex, and what the best way to do it would be. I may put Next Previous buttons below the datagrid and that will be what sends the limit variables. I was looking for a way to hopefully do it dynamically, but not having much

Re: [flexcoders] Re: Handle Large Dataset

2008-05-07 Thread Robert Cadena
Hi David, hmm, too bad it's not working. Here's an example of a running app using that code as the original base: http://labs.searchcoders.com/dashboard/dashboard_latest.air what might help is to return a result set, which includes: total size of result items: array of results that way you