he hosts my sites - i'll repost it:
I've got the following queries running quite regularly
ORDER BY date DESC
WHERE cat=500 AND approved=1
ORDER BY disporder,date DESC
if I replace the select line with a count(*) the first query returns a count of 238,344 records, and the second query returns a count of 41,302.
what can I do to limit the number of records these queries return? And or what pages would run these queries?