From: Jesse E. <je...@er...> - 2006-03-13 19:29:24
|
> Poetic Justice :) >=20 > Seriously, this is not the intended use of a category tree. =20 > I think you > should have done something more automated for your attempted Google > hijacking. However, there was discussion in the past about making the > category tree load incrementally. I think Jesse was considering it. > Check the archives. Lol.. I'm not so sure what this is justice for, however. It might be justice for us making categories So Important in Krang. I have at least one project I'm working on which is a Krang site with at least 11,000 categories, so I know the pain of which you speak, Nick. The problem is the category chooser HTML widget. Only on screens which have the tree chooser do you have that problem. (Generally, few other parts of the system really suffer as a result of many categories.) The theoretical solution is to use Sam's "HTML::PopupTreeSelect::Dynamic" module to select categories incrementally. A more tame solution would be to from the tree chooser and use an interface similar to the "StoryLink" selection mechanism (forward to a category search screen with "select" buttons). Other places which suffer from having many categories: The Groups and Users manager apps. This is largely due to the maintenance of the "user_category_permission_cache" table, which contains one row per user, per category. IOW, if you have 50 users and 11,000 categories, there will be 550,000 rows in this table. Warmest regards, -Jesse- -- =20 Jesse Erlbaum The Erlbaum Group je...@er... Phone: 212-684-6161 Fax: 212-684-6226 =20 |