lcrocker(a)nupedia.com wrote:
>The
"Astronomer" page contains an extraordinary number of links,
>mostly to "year" pages. Each link on a page requires a database
>lookup (a quick one, but still a lookup). "Current events" had
>the same problem before I reorganized it. I'm inclined to just
>remove the year links here. They don't really serve much purpose.
>
>
Argh! I didn't notice that. Thanks for
pointing that out.
Wouldn't page caching sort this, though?
I have something of a love/hate relationship with caching. It
solves some problems, and it creates others. I'd like to avoid
it if possible, and I think it is possible. But I may be proven
wrong about that if people create lots of other link-fest pages.
Lee,
I haven't read the code, but do you do the lookups as lots of individual
SQL calls per link, or do you gather up a list of them and do a single
SQL call? This might improve performance, as possibly might doing the
lookups in batches, if the latency/pipelining hit would be too much for
a single call?
Neil