On dim, 2002-05-12 at 08:17, Magnus Manske wrote:
> > > I suggest to add two new fields to the database (cur table)
> > > * cur_namespace (varchar) so articles can be distinguished by namespace
> > > without using the "LIKE" MySQL query (this was mentioned before)
> >
> > Should there be a separate title-without-namespace field as well, or
> > would cur_title now be that?
>
> I think a namespace field would do fine for now, as most of the slow queries
> look for the namespace.
Well, the statistics checks do I suppose, but the watchlist and
list-all-namespaces functions check for everything with the same
non-namespace portion. No?
> > > * cur_is_redirect (boolean) so #REDIRECT pages can be excluded likewise
> >
> > Not a bad idea! Might it be even easier to make it a string field which
> > contains the name of the page being redirected to? This would save
> > parsing the #REDIRECT [[x]] line or relying on the link tables when
> > doing mass checks in, eg, "links to this page".
>
> I agree. A boolean field might be faster, but not by much.
>
>
> Concerning the {{NUMBEROFARTICLES}} function, we should implement a
> cur_has_commas (boolean) field while we're at it. It seems to be the best
> way of telling articles apart from stubs. Or, we should name it
> cur_is_article, in case we come up with a better method some day.
Or, we could just update the value once a day. :)
Actually, that reminds me: should we add a timestamp field to indicate
when cur_cache was last filled? A simple check of that against
cur_timestamp would have prevented our present cache-of-ancient-
version-is-displayed-instead-of-recent-one troubles.
It would then be possible to expire caches on certain pages, such as
those containing {{variables}}.
-- brion vibber (brion @ pobox.com)