Re: [flexcoders] Number of records in a Datagrid
From a usability point of view, it would notbe a good ideato 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-sidefiltering pointless.no point filtering results only on the 1000 or so that you have, andhitting the DB and doing server filtering runs in to the 2 secondreturn...which makes experience less seemless than I would like.On the labs.adobe.com, in the Showcase is a very clever "BrightPointDashboard" application that is filtering 6 records client side,and you can view ALL the records in a datagrid. There is a little bitof performance degragation if you scroll the grid very quickly, butthe grid still works very well.Check it out, it's very kool! (well done Thomas!)CheersOn 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.
RE: [flexcoders] Number of records in a Datagrid
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.
RE: [flexcoders] Number of records in a Datagrid
In 1.5, the bottleneck is the ui instantiation. Even though 8.0 was a massive improvement in instantiation speed it is still probably the issue in 2.0. As you noticed, getting the data back is quite fast, so why not load up a local data store, and then use paging techniques to display the data? Matt Chotin has a treatment of the large data set issue on his blog. Also, depending on your use case, consider using a list with a custom renderer, particularly if you don't need the DataGrid's column resizing/sorting functionality. This issue also shows up using a repeater: Rendering 100 complex items is unbearably slow, while doing 5, with page-up, page-down is blazing. Tracy -Original Message- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of David Harris Sent: Monday, May 15, 2006 6: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.
Re: [flexcoders] Number of records in a Datagrid
Hi Tracey, Thanks. I'll check out Matts Blog, as he may have an idea! :-P I have had issues in the past on speed using custom renderers, and have heard repeaters have issues when there are to many rows. Cheers On 5/16/06, Tracy Spratt [EMAIL PROTECTED] wrote: In 1.5, the bottleneck is the ui instantiation. Even though 8.0 was a massive improvement in instantiation speed it is still probably the issue in 2.0. As you noticed, getting the data back is quite fast, so why not load up a local data store, and then use paging techniques to display the data? Matt Chotin has a treatment of the large data set issue on his blog. Also, depending on your use case, consider using a list with a custom renderer, particularly if you don't need the DataGrid's column resizing/sorting functionality. This issue also shows up using a repeater: Rendering 100 complex items is unbearably slow, while doing 5, with page-up, page-down is blazing. Tracy -Original Message- From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of David Harris Sent: Monday, May 15, 2006 6: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 SPONSORED LINKS Web site design development Computer software development Software design and development Macromedia flex Software development best practice 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.
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 6 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.