Ken, Hmmm.. Maybe I will look into jQuery tabs. but I will need help with that as well!
Thanks, Milind. From: [email protected] Date: Thu, 18 Apr 2013 16:48:29 -0500 Subject: Re: [houcfug] Help with Dynamic Data Scrolling To: [email protected] Milind,To see if shrinking the number of rows you pull at a time is a worthwhile endeavor, try changing your CFQuery to use numrows="30" (or use "select top 30, etc" directly in the query to give a smaller result set) and see how long that takes compared to running the full query. In a later email response to someone else, you say you don't have time to touch loading the tabs only when they are used.food for thought: It isn't as hard as it sounds and could help you a lot. Good luck!--Ken On Thu, Apr 18, 2013 at 4:15 PM, Milind Pataskar <[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] Date: Thu, 18 Apr 2013 15:54:33 -0500 Subject: Re: [houcfug] Help with Dynamic Data Scrolling To: [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]> 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] 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. -- -- 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. -- -- 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. -- -- 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. -- -- 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.
