That example is infinite scrolling - it's simply giving the user visual feedback, like Twitter does, versus scrolling in a table, where the effect is less obvious (the scroll bar grabber changes size as more content is loaded in).
As for offering the user many controls (action icons) as you mentioned, you can certainly use a primary icon that triggers a popup or dropdown box containing all the tools they need - Bootstrap's Dropdown offers this feature, and there are other JQuery tools similar to it out there. If there are many joins (and I know you don't have access to the person who created the table), a stored procedure might be another way of approaching the problem (I've used a SP before when pulling together a large recordset with many joins to save on load time). James E. Thomas Baker Botts L.L.P. Development Manager, IT Practice Support O: 713.229.2196 | M: 832.373.8117 | F: 713.229.8130 From: [email protected] [mailto:[email protected]] On Behalf Of Milind Pataskar Sent: Thursday, April 18, 2013 4:27 PM To: [email protected] Subject: RE: [houcfug] Help with Dynamic Data Scrolling Mike, You are essentially correct. I am trying to borrow that idea from the mobile devices. The following example shows what I want to do (except no in an infinite way): http://alphacommunications.com/search.php?find=ir If you scroll all the way down, it shows a spinner and load a set number of rows to display. Any help? Milind. ________________________________ From: [email protected]<mailto:[email protected]> Date: Thu, 18 Apr 2013 16:21:17 -0500 Subject: Re: [houcfug] Help with Dynamic Data Scrolling To: [email protected]<mailto:[email protected]> Miland, We do that in our apps. We actually load 50, and when the user scrolls to the bottom we dynamically load 50 more Sent from my iPhone On Apr 18, 2013, at 4:15 PM, Milind Pataskar <[email protected]<mailto:[email protected]>> wrote: Ken, I wont get access to the DBA and probably the tables are correctly indexed. The loading is slow because the page is loading multiple queries (that the user may or may not be interested) for other tabs as well. Our main concerned table has got many joins (and surely the other un-needed query/tables as well). Probably that is what is causing the actual query to load slow. Maybe my 200 row number was small. What if there were 400 total rows to be selected and shown. But I want to show only 100 on the first load and perhaps load and show 50 rows every time the user scroll at the bottom of the page. James Thomas, I will look at the datatables link but I need to show quite a few actions icons on every row. Do not know if your solution allows that. Thanks guys for you help. Keep on sending. Milind. ________________________________ From: [email protected]<mailto:[email protected]> Date: Thu, 18 Apr 2013 15:54:33 -0500 Subject: Re: [houcfug] Help with Dynamic Data Scrolling To: [email protected]<mailto:[email protected]> Milind, Because you through out the number 200, I don't think dynamic data load will help you here... The dynamic load and infinite scroll solutions are only really helpful if you are only showing a very small percentage of the data at one time. since you want 25%, you may as well pull it all in at once. Your speed problem is more than likely that you need more proper indexes on the DB tables. If you work on the DB performance, and set it up to load the data for each tab when you go to that tab, then pulling 200 records should be pretty fast. HTH! --Ken On Thu, Apr 18, 2013 at 3:35 PM, Milind Pataskar <[email protected]<mailto:[email protected]>> wrote: Hello all, Our query returns a huge data and I need to cut down on the on the page load time. To further complicate the matter, the page has got multiple tabs and upon a quick glance, I realize that they are running all the queries for all the tabs at the beginning. But only the contents of the current tab are shown. SO: For now lets even ignore the loading of all queries for all tabs. All I'm concerned is how do I load and show the first 50 rows returned from the query and then have a "On Demand Data Load" and "Dynamic Data Scrolling". Mind you, I do not want the "Infinite Scroll" because my table has a finite data (lets say 200 rows). I tried searching solutions in jQuery and AJAX but there is too much information to sift from. Has anybody successfully implemented Dynamic Data Scrolling (with a spinner as the data is being fetched) ? Please help. Thanks, Milind. -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:houcfug%[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. Confidentiality Notice: The information contained in this email and any attachments is intended only for the recipient[s] listed above and may be privileged and confidential. Any dissemination, copying, or use of or reliance upon such information by or to anyone other than the recipient[s] listed above is prohibited. If you have received this message in error, please notify the sender immediately at the email address above and destroy any and all copies of this message. -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
