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)