On sab, 2003-02-01 at 10:31, Jan Hidders wrote:
Btw., shouldn't namespace be in there somehwere or
is that still a
part of the title?
On the link tables, the title strings include the (text) namespace. That
might not be the best way about it, though.
(For that matter, the links table should probably just be
cur_id-to-cur_id, so we can grab the titles & namespaces on a join. Or
is it useful to store it separately?)
I suspect we
can be smarter about how we update links and brokenlinks as
well; currently we just delete every row pertaining to the page we're
dealing with and re-insert it.
Probably, because when a page is saved you have to retrieve the "old" broken
links from the DB anyway because there is no other way of knowing them and
you need them to updated the wantedpages table. So you might as well compare
them to the new list of broken links and remove/add only what has changed,
which is usually only a few links anyway.
Sounds reasonable.
-- brion vibber (brion @
pobox.com)