Taxonomy.php Problem – # or ID's selected to run causing slowdown

Hi all
I’m having a problem with a large number of queries being sent at one time through “taxonomy.php”. I have a large number of posts (~200,000) listed in about 170 categories. I was wondering if there is a way I could limit the number of id’s being selected, as described below, without breaking my installation…?

From my server admin:

“Hello Frank,

This is actually being ran by WordPress in one of the default files, ‘taxonomy.php’ in the wp-includes directory. The issue is a combination of two things, mostly the query and the large amount of term_taxonomy_id items being selected (51). If I select only 5 items from that column instead of 51, the query only searches through 8,843 rows, rather than the entire table.

The cause of the issue seems to be that each individual listing on the page is a post, and the way WordPress references these items. WordPress is essentially not coded in a way that is optimized for this kind of site (lots of individual pages).

mysql> select count(*) from wp_posts;
+———-+
| count(*) |
+———-+
| 192590 |
+———-+
1 row in set (0.01 sec)”

Thanks in advance.
Frank