[thesite] friday is a good day..

Warden, Matt mwarden at odyssey-design.com
Fri May 18 14:32:29 CDT 2001

Hash: SHA1

> Quick comment that *may* help.  The query used to drive the front
> end is using 3 conditionals to exclude categories.  Would it
> possibly be faster to add a flag to the category to indicate
> whether it should be included on the front of the site, thereby
> reducing the number of comparisons and allowing you to maybe even
> use an index (maybe clustered) on that flag?

rudy, is it in the plans to use a PRIV column on categories?
Truthfully, it might not be the intended use and I can see you
telling me we shouldn't use the PRIV column for this, BUT setting the
priv of those categories to 3 (or 5 if you want to have it not
displayed for anyone) could keep them out of things like the front
page, headlines mailers, XML headline feeds, etc. The only problem I
see is if we ever get into showing or not showing an article based on
the PRIV of its category (not sure why we would do this since the
article itself would have a PRIV).

Where is the latest database design diagram (heh, yes, I remember you
told me you hadn't updated in a while. and this certainly isn't me
trying to get you to do that *cough*)? Getting the PRIV system in
place will solve a good number of problems, IMO. AFAIK, it's only
being used for admin-type stuff.


- --

Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>


More information about the thesite mailing list