ObjectLinkRef table

[Aaron Turner <aturner@linuxkb.org>]

Ok, I'm looking for info and suggestions.  From what I can tell the
ObjectLinkRef table not only links categories/articles under other
categories other than their primary, but also links authors to articles
and things like that (anything else?).  This should make this a rather
large table as time goes on.

Q1:  ObjectID is the "parent" and LinkObjectID is the child?  Ie:

ObjectID=15, LinkObjectID=19 where 15=Applications and 19=netscape would
put netscape under applications.

Q2:  What is a good algorithm\SQL for finding specific kinds of links in
this table?  Ie, how do I find all the links which link a category under
another category?  Or link an article under a secondary
category/application?  Right now it seems that I have to do a select for
each ObjectID of the type I'm looking for.  So if there are 1000 articles
of which say 50 have 2ndary categories, I have to do 1000 queries, one for
each article.  This sounds very non-optimal performance wise, but I
understand that this is part of normalizing a database (don't store the
same info twice).

--
Aaron Turner, Core Developer       http://vodka.linuxkb.org/~aturner/
Linux Knowledge Base Organization  http://www.linuxkb.org/
Because world domination requires quality open documentation.
aka: aturner@vicinity.com, aturner@pobox.com, ion_beam_head@ashtech.net
The difference between `Unstable' and `Usable' is only two characters: NT