title: Codeigniter pagination avoid LIMIT with OFFSET
body: <p>Is there anyway to avoid using LIMIT $page,$offset when retrieving rows in codeigniter pagination?</p>
  
  <p>When i use limit with offset on milions records when retrieving for example LIMIT 300000,45 query takes about 6 second more then retrieving  LIMIT 45,45</p>
  
  <p>Which is the best and fastest way to paginate records?</p>
  
  <p>thanks :)</p>
  
  <p>My table looks so:</p>
  
  <p>id (AUTO) | username | password | email </p>
  
  <p>i used a simple query:</p>
  
  <p>SELECT * FROM table ORDER_BY username ASC LIMIT 300000,45</p>