title: Limiting query_posts in Wordpress, but still having pagination
body: <p>I really hope someone can help me.  Basically I have a Wordpress site I am using as an affiliate site.  I have about 1/2 million posts, which are essentially the products.  The site is running fine, except for on the category pages where there are more than 5,000 posts. If someone was searching for a product they probaby wouldn't go past page 10 in the search results, so What I'd like to do is limit the query_posts results returned to 500 posts.  But still have 25 posts per page.  Does anyone know if this possible?</p>