[Catalyst] Singleton or Memcache

[A. Pagaltzis]

* Matthias Ludwig <matthias at kl-mailer.de> [2006-10-18 09:05]:
> On every category- and article-page there should be a "way to
> the top" with links to every base-category (up to the root). In
> the database every category has a id, base_id and a name (<=100
> chars). Every article has category_id that references the
> category.

You can fetch the entire hierarchy with a single query:
http://www.developer.com/db/article.php/3517366

See also http://www.google.com/search?q=nested+set in general.

Regards,
-- 
Aristotle Pagaltzis // <http://plasmasturm.org/>