On Tue, Nov 19, 2002 at 09:55:35AM +0100, Magnus Manske wrote:
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:%" ;
That's how I did it in Phase II. Did work, but this works better. And,
namespaces are currently *not* part of the title in the database!
Ah, ok. In Phase II was an index defined on the article_title column?
Postgres has b-tree, r-tree, hash, and various other kinds of indexes
that make even string searching blazing fast.
In the sample database Brion posted, I must have overlooked the table
that mapped between namespace Id's, and the name of the namespace.
Namespaces are convenient conceptually, but are they really necessary?
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