|
he hosts my sites - i'll repost it:
I've got the following queries running quite regularly
SELECT username,id,date,photo
FROM pp_comments
ORDER BY date DESC
SELECT id,bigimage,cat,userid,approved,storecat,height,width
FROM pp_photos
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?
|