Check out the SMF Function DB!
it doesnt seem to be slow on my host at all presently
no... the script does not make only 10 requests per page.It requests all 100, then parses them to check if the user has access to see those postsTHEN it paginates and displays...so, by asking for 200, you have now DOUBLED the load.