On 2/20/07, Jim Hu jimhu@tamu.edu wrote:
I'm developing the extension for 1.8.3. I have now gotten the basic version working with the minor hack to CategoryPage.php.
So far, it improves on CategoryPage.php in two ways: Shows the subcategories no matter how many articles are shown Shows the real counts for articles when the number is >200.
I'm hoping to make it more like Special:Allpages next...I'm using it on a wiki where there are categories with >100K articles in the biggest categories:
http://gowiki.tamu.edu/GO/wiki/index.php/Category:Eukaryota
Paging through 200 at a time gets old fast!!
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).