Might not be your solution but you could try using bDisplayCategories=0 in your genericAdmin calls, this will remove the category selections and should hopefully remove the queries as well.
Yeah I�m doing that now. The guys at daemon probably had some reson doing the displayTree.cfm the way they did. But querying the database for every object sure isn�t fast. Joe Celko did this nested tree model so that the impact on the sql server should be low. Gonna look at this when I�ve released my site if anybody dosn�t have any solution ready.
The site I�m building is a news portal, that�s why there are so many categories.
Yeah the category tree at the bottom of generic admin is not built efficiently. The per node building is supposed to only happen for a tree that is built as you request nodes -- which makes sense (eg. site overview tree, category management tree).
The tree at the bottom of Generic Admin just builds the whole thing in one go a node at a time -- which is not great.
Feel free to contribute a more efficient tree-form widget for categories :)
-- geoff http://www.daemon.com.au/
--- You are currently subscribed to farcry-dev as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
