Just wondering...
Would it be worth denormalizing categorylinks a bit so that CategoryPage.php doesn't have to join categorylinks and page? I'm thinking that having page_title and page_namespace duplicated there would help performance. In particular, I'm wondering if getting rid of the join would speed things up enough to make some of the things we're doing with our modified category page extensions tolerable on other sites (i.e. get real counts for how many subcategories, find the subcategories even when they don't sort within the limit etc.) and faster on ours.
I know that it violates all kinds of sacred db design principles and is therefore probably a bad idea. Is this a job for (materialized) views? ===================================== Jim Hu Associate Professor Dept. of Biochemistry and Biophysics 2128 TAMU Texas A&M Univ. College Station, TX 77843-2128 979-862-4054
mediawiki-l@lists.wikimedia.org