Limit By x reduce server load ?
 

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

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

however what if the query is a little more complex.

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

Pagination is always better than querying the whole database :)

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