title: does zend paginator ultimately use LIMIT OFFSET
body: <p>so I'm currently using Zend Paginator because I'm having the impression that it doesn't ultimately use <code>LIMIT x OFFSET y</code> or <code>LIMIT x,y</code> queries and is therefore efficient even if I'm trying to seek page 99999 since LIMIT OFFSET would need to search through all items from the first one to the ones in page 99999 if I were to use LIMIT OFFSET...am I correct or incorrect in this assumption? </p>