On Tue, Dec 10, 2002 at 03:16:51PM -0800, Brion Vibber wrote:
Ah. I was assuming that empty articles wouldn't exist unless they had been purposely cleared in an edit war. *cough*RK*cough*
The stub detector marks links to articles below an (arbitrary, user-selectable) size as with a distinct link class.
Well, IF we are not going to store article sizes separately, then we need to retrieve the text of all articles linked to when we render an article page. And THAT means I can do this with a single query after all, instead of three.
A note about searching: with Postgres we can just set up the UTF-8 collation on the article text fields, and then we can use LIKE clauses to search for text in the articles and titles, and the characters will be collated correctly, without any extra coding on our part. Another reason I am eager to use Postgres. The search engine will be trivial.
Will that be reasonably fast? How would we rank pages in the search?
Yes, quite fast. We can rank pages however we want; we could use an ORDER BY clause to sort results by article title, or by timestamp, or anything.
How is searching currently done?
Jonathan