Re: [Wikitech-l] Inheritance problem for CategoryPage.php

FWIW, Count may be slow, but the slow step in generating the Category page is probably a combination of sorting the return in mysql and stepping through the query results in php. On my outdated Mac OSX dual G5 server, I get the following with my pre-beta extension, using a category with 124,520 articles and 3 subcategories Count the articles: 5 sec Do the query method: 16-24 sec n = 3 For a category with 74945 articles Count the articles: 2-3 sec Do the query method: 9-10 sec n = 3 this is by putting time() calls in the code and subtracting. This is right on the edge of not working at all, and sometimes when I load the page it fails. Of course, I ran the tests while some spammer was trying to flood my server on another application. The query numbers are much higher than one would get for the real CategoryPage.php, since I the query to collect all the subcategories has to traverse the whole list of categorylinks. I'm hoping faster hardware will help. Or at some point, perhaps I should just show the count and write a message to the screen like: "You really don't want to click through all the pages of articles. Try a subcategory instead!" ;) More seriously, I wonder if it would be worth having a cron job periodically generate denormalized tables for the articles and subcategories in general. Oh, and I'm still wondering about the inheritance problem. Jim ===================================== Jim Hu Associate Professor Dept. of Biochemistry and Biophysics 2128 TAMU Texas A&M Univ. College Station, TX 77843-2128 979-862-4054 On Feb 20, 2007, at 2:04 PM, Jim Hu wrote: