Re: [flexcoders] Number of records in a Datagrid

[Sreejith Unnikrishnan]

From a usability point of view, it would not be a good idea to display 15,000 records.   Would you try this instead ... Fetch all the data, use lazy loader if necessary and store it as say 'fetchedData' Create an ArrayCollection 'filteredData' from the fetchedData, that contains about 100 records sorted in say alphabetical order Every time you click sort or you want to filter, act on 'fetchedData', get the first 100 records and repopulate 'filteredData' If you want to include paging send a paramater that says get the next 100. Sree  ----- Original Message ----- From: David Harris To: flexcoders@yahoogroups.com Sent: Tuesday, May 16, 2006 4:31 AM Subject: Re: [flexcoders] Number of records in a Datagrid Hi Kelly, thanks for your suggestion, but paging results makes any client-side filtering pointless. no point filtering results only on the 1000 or so that you have, and hitting the DB and doing server filtering runs in to the 2 second return...which makes experience less seemless than I would like. On the labs.adobe.com, in the Showcase is a very clever "BrightPoint Dashboard" application that is filtering 60000 records client side, and you can view ALL the records in a datagrid. There is a little bit of performance degragation if you scroll the grid very quickly, but the grid still works very well. Check it out, it's very kool! (well done Thomas!) Cheers On 5/16/06, Kelly @ Dekayd Media Inc. <[EMAIL PROTECTED]> wrote: > >  Why are you not considering paging the result set? > >  15,000 records are way too many to be useful for display and are certainly >  going to cause performance issues. > > >  This is just my opinion. > > > >  --Kelly > > > >  -----Original Message----- >  From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On >  Behalf Of David Harris >  Sent: Monday, May 15, 2006 3:07 PM >  To: flexcoders@yahoogroups.com >  Subject: [flexcoders] Number of records in a Datagrid > >  Hi, > >  Does anyone have an idea of how many records in a datagrid are to many? > >  I have a situation when the Flex2 SWF loads, the it hits the DB and >  retrives records. >  If I am retriving 100 records it takes about 2 seconds. >  If I am retriving 15000 records it takes more than 3 mins, even though >  the CFC is completing the call to the DB and returning the records in >  2 secs. >  I am running all this locally on my system, so network speed issues >  are not a consideration. > >  Anyone else had issues with large queries? > >  Cheers, > >  David > > > >  -- >  Flexcoders Mailing List >  FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt >  Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com >  Yahoo! Groups Links > > > > > > > > > >  -- >  Flexcoders Mailing List >  FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt >  Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com > > > >  ________________________________ >  YAHOO! GROUPS LINKS > > >  Visit your group "flexcoders" on the web. > >  To unsubscribe from this group, send an email to: >  [EMAIL PROTECTED] > >  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > >  ________________________________ > -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com YAHOO! GROUPS LINKS  Visit your group "flexcoders" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.