On 2/20/07, Simetrical Simetrical+wikilist@gmail.com wrote:
Are you using COUNT(*)? That's O(N) on InnoDB, which is why we don't use it: too slow for large categories. If you have an extra field in the database somewhere rather than COUNT(*), maybe it would be good for trunk (although that's for Tim, Domas, etc. to decide).
O(N).. er. Ah, you mean O(N) on results...