jQuery tabs are pretty easy, like all the widgets they do the heavy lifting for you. Just remember that it is much more simple than you think it is.
http://api.jqueryui.com/tabs/ M On Thu, Apr 18, 2013 at 4:51 PM, Milind Pataskar <[email protected]> wrote: > 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. > > > -- -- 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.
