On 12/10/06, Aerik Sylvan <aerik(a)thesylvans.com> wrote:
Here's something that looks promising: Using
MySQL's fulltext search
against categories only. What I did was create a table having pagenumbers
and category text that looks like this:
Last I checked mysql FTI requires the underlying table not be innodb.
Thus no crash recovery.
In general any approach which performs well for FTI will perform well
for category intersections. The postgresql examples I posted a while
back using gist and inverted index are both normally used for FTI.