[thesite] friday is a good day..

[Warden, Matt]

-----BEGIN PGP SIGNED MESSAGE-----
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.


r0ck,


- --
mattwarden
mattwarden.com

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

iQA/AwUBOwV43ngH0dUmEhrcEQJRLwCgyRzwp3py8gPGaz0JeXT6aa3SS4UAn0YT
P35y08aWxk2FUujEsgMh+Yz0
=5qJL
-----END PGP SIGNATURE-----