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.
