Is a separate integer namespace property actually necessary? I got the
impresion that namespaces were designated by a prefix in the article
title, such as Special:, User:, or Wiki:
In that case, one could find all the articles in the Wiki: namespace by
doing this query:
SELECT article_id FROM cur WHERE title LIKE "Wiki:%" ;
And if we had some indexes defined, that search would actually be
extremely quick to do.
Any reasons why we need to keep a separate column for "namespace"?
If we want to keep namespaces in their own column, maybe we should have
a table of namespace id's and their corresponding prefix, and then NOT
put that prefix as part of the articles actual title.
Jonathan
--
Geek House Productions, Ltd.
Providing Unix & Internet Contracting and Consulting,
QA Testing, Technical Documentation, Systems Design & Implementation,
General Programming, E-commerce, Web & Mail Services since 1998
Phone: 604-435-1205
Email: djw(a)reactor-core.org
Webpage:
http://reactor-core.org
Address: 2459 E 41st Ave, Vancouver, BC V5R2W2