On 12/09/06, Aerik Sylvan aerik@thesylvans.com wrote:
So, *if* throwing sql at the existing table is too slow (and it looks like it probably is), then the next alternative is to create records for the intersections themselves, so the retrieval query is a simple one. This would make the write time longer, but save a lot on the many reads. So, here's a table of how many combinations that would have to be written for up to 10 categories. Anybody have a histogram of how many categories are on a given page? I'd also guess pages would tend to get *more* categories once the intersection tool is available.
Well, yes ... How does other software with arbitrary tags do it?
- d.