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
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
