This is quite a preposterous proposition. 15 million records and user can view 100 records at a time? 15million divided by 100 equates to 150,000 thumb movement. assuming a thumb movement of even 5 times per second, it would still take 30,000 seconds or roughly 8.33 hours assuming your user is not even looking at the data.
everything has a limit, whether its flex, java, .net, ruby or any other devt framework out there. perhaps it is time to rethink this functionality and the need that your user would derive from it. ________________________________ From: iloveyouwisconsin <[email protected]> To: [email protected] Sent: Mon, 15 March, 2010 17:32:33 Subject: [flexcoders] Re: Flex 4....Large recordset...how much is too much? We have a need for that in our project. I will say that much w/out giving away the idea. The question, though, is why is Flex (without hacks) limiting the amount of data we can view? The datagrid should be smarter than it is and in my opinion has a long way to go in order to be a truly viable means for data-intensive applications. Remember, I'm not VIEWING 15 million records at ONCE. I'm only retrieving 25 or 100 rows at a time from a database that is 15 million records. I want to give the user the OPTION of jumping around the database via moving the thumb around on the scrollbar... without crashing the application. As a workaround (at least in the short-term), how could I force the thumb icon to the bottom of the scrollbar after a user scrolls, like they do here: http://blog. tremend.ro/ 2009/03/02/ flex-live- scroll-datagrid? I know that they have source enabled, but the switch to flex 4 (and paging enabled on my php service) would change the entire process, right? --- In flexcod...@yahoogro ups.com, "gmbroth" <gmbr...@... > wrote: > > I'm curious: what's the use case for pushing 15 million (or, heck, even > 50,000) records to the client? > > > --- In flexcod...@yahoogro ups.com, "iloveyouwisconsin" <iloveyouwisconsin@ > > wrote: > > > > Maybe I'll have to wait until Flex 7 (or later) 'til they truly make flex > > able to handle large datasets smoothly. (I guess I'll also have to advise > > those at Adobe and the flex evangelists that what they define as a "large" > > dataset isn't large in practice. They probably need to moonlight as interns > > for a few of their customers to snapback into reality. There's no company > > in the real world that would define a large dataset as only a few thousand > > items) > > > > --- In flexcod...@yahoogro ups.com, "iloveyouwisconsin" <iloveyouwisconsin@ > > > wrote: > > > > > > How many records is considered "too large" for a datagrid to handle? I am > > > using Flex 4 with Zend AMF & paging enabled. When I google it the topic, > > > most seem to think that a "few thousand" is large, but that doesn't seem > > > hardly anything to me. I thought Zend would do the trick but it isn't > > > anywhere near what I need. My 15 million records didn't go over too well > > > (I can use the scroll wheel on my mouse to scroll through the records but > > > it kept crashing when I tried to use the scrollbar on the datagrid to > > > jump around). I ask because I don't want to have to jimmy around with > > > code until I'm blue in the face trying to find something flex can handle. > > > Can I do 1 million? 5,000? 500,000? I just want to be able to let users > > > play around w/ the scrollbar on the datagrid without it crashing, is all > > > (though I realize that the user's machine will play a big factor in > > > performance. All of my users have computers that are no more than a > > > couple yrs old) > > > > > > I also ask because I am sure others would like to know for their > > > projects.... is there a more efficient way to get the data than Zend, > > > like Livecycle or Coldfusion? I am willing to switch the backend up a bit > > > in order to increase performance of my app. > > > > > > > > > many thanks! > > > > > >
