On 12/11/06, Aerik Sylvan <aerik(a)thesylvans.com> wrote:
[snip]
And, as always, anybody else got any ideas? If this
can't work, I can't
think of anything else beside a separate Lucene index (which will then not
be real time and have to be updated every so often) as I don't think
excluding large categories from an intersection search is an acceptable
solution.
If we're willing to go external, there are lots of possible solutions.
(Including lucene). Being external doesn't preclude real-time or near
real time. Something could scan recent changes, and go and check to
see if the categories have changed. Load could be limited by
dampening the polling of a single article to N times in a M hour
window.
And of course, I agree that excluding large categories is not a
solution. In an ideal world where we had working support for category
logic, many categories would be rather long. Categories as a tool for
direct navigation is an antiquated idea, ... more flexible and
suitable tools like portals and navboxes mostly replaced categories as
a direct navigational tool ages ago.