RE: [Krang-general] Too many categories

[Jesse E. <je...@er...>]

> 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