Limit By x reduce server load ?

[DPoole]

If I were to write a query that asks for a certain variable for all members and list them

Would it reduce the server load if I were to show them as vb does as pages, say 30 at a time.

I know it would speed up page loads as it wouldn't have to load everything

I can guess that this would be true for a simple query as in


$DB_site->query("SELECT postid, username FROM post ORDER BY dateline LIMIT 30");



because it just sorts the table dateline and just brings back the first 30

however what if the query is a little more complex.


$DB_site->query("SELECT SUM(post.postrate) AS postrate
FROM post
GROUP BY post.userid
ORDER BY postrate ASC Limit 30");


Now in this case does it have to query the whole post table ( is just an example ) adding up all the values in order to sort them ?

Is this therefore a lot more intensive ? Or is there only a small increase ?

Just following on from this, how do I code the page system, if I limit the results by 30 for a page, how do I do the code for page 2, where I want the results from 30 - 60 etc ?

Hope I've made sense here :D

[Dean C]

Pagination is always better than querying the whole database :)

[DPoole]

any idea on the code m8 to split it into seperate pages.