[thesite] faster queries on new w.e.o

[Warden, Matt]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

>     (SELECT Count(*) FROM replies WHERE contentid =
> content.contentid AND datemod > '') AS newcomments

.jeff, you still planning on whacking the above when the user is not
logged in (or, actually, you might as well just test for
session.lastvisit (or whatever it is) instead, no?)?

That ought to hack off a bit (unless the "remember me" feature is on,
of course).


nice.



- --
mattwarden
mattwarden.com

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

iQA/AwUBOwrhKngH0dUmEhrcEQKl0QCggz0ePmL8+L084Izbz+5Ke98GWcoAn057
ThKiWnBkCRaUPfnvCFWENUkQ
=Hq6q
-----END PGP SIGNATURE-----