I have something like this (though not 215 seconds worth) and get around it by only running the nested queries when a change is made and it creates a hard page (which can be CFinserted as required)
John Quarto-vonTivadar wrote: > > You mean the Joe Celko model? It's a great way to store tree data and to > manipulate it but if you're hitting it every time for display then it's > no wonder you have a slowdown. Really, what should be done is to store > the info in the Celko model and then everytime something changes to > store the newly completed tree somewhere (or in a separate table?) where > it can be quickly retrieved. Changes to trees are made during "upkeep" > etc but then displaying the tree between changes would be redundant to > 'regenerate' the tree > > You could do the generation of the tree and then use a separate table > (obviously non-normalized) which records ordered from top to bottom in > the way determined by the actual tree query. You could also save it as > XML at that point too. > > -----Original Message----- > From: Luce, Greg [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 08, 2003 3:01 PM > To: CF-Talk > Subject: Nested Tree DHTML > > I have a nested tree built with Steve Nelson's model. I'm also > presenting it with the tigra tree DHTML package. It's gotten so large it > takes 215 seconds to resolve even with the query cached! The package > takes one long character string and parses it out into tables and such. > Any ideas on how to speed this up? I had thought originally that caching > the query and possibly even running it in the background as a task would > make it workable, but no. Queries > > application.tree (Records=6917, Time=Cached Query) > SQL = > SELECT Child.Category_ID, Child.Category_Name, > Count(Child.StartBranch) > AS lvl, > Child.StartBranch, Child.EndBranch > FROM category_tree AS Parent, category_tree AS Child > WHERE Child.StartBranch BETWEEN Parent.StartBranch AND > Parent.EndBranch > GROUP BY Child.StartBranch, Child.Category_ID, > Child.Category_Name, Child.EndBranch > ORDER BY Child.StartBranch > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
