On 12/10/06, Aerik Sylvan aerik@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.