The basic sitemap.php ( showing a total list of blog's posts) - the core line reads:
<?php $archive_query = new WP_Query('showposts=1000'); while ($archive_query->have_posts()) : $archive_query->the_post(); ?>
works fine on one blog , but becomes an issue on another.
Those two blogs sit on two different hosts.
The first one never exceeds 33 queries on the sitemap page, the second one's queries keeps going up while new posts being published and hit a thousand queries, then it reached PHP memory limit. A sysadmin increased that limit but sure enough it reached the ceiling soon and that sitemap page is disabled now.
The sysadmin isn't cooperative and blows me off when I imply that's his server's settings need to be checked ( The same script, like I said works fine on the another host).
Any idea to give the sysadmin a clue, please?