Re: Nested Tree DHTML
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 = SELECTChild.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=subscribeforumid=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
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 = SELECTChild.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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Nested Tree DHTML
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 = SELECTChild.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=subscribeforumid=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
Re: Nested Tree DHTML
Luce, Greg wrote: I have a nested tree built with Steve Nelson's model. Looks a lot like Joe Celko's nested tree model to me. 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! Cached queries typically don't cost time. So the problem is probably the amount of traffic over the net (HTTP compression is turned on?) or the amount of work the client side has to do. The package takes one long character string and parses it out into tables and such. Any ideas on how to speed this up? The tigra tree DHTML package looks rather complex to me. Take a look at http://www.gazingus.org/html/menuExpandable3.html for an extremely slick expandable menu. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4