Pagination avoid LIMIT with offset in query?

[eluser]Ngulo[/eluser]
Is there anyway to avoid using LIMIT $page,$offset when retrieving rows in codeigniter pagination?

When i use limit with offset on milions records when retrieving for example LIMIT 45,300000 query takes about 6 second more then retrieving LIMIT 45,45

Which is the best and fastest way to paginate records?

thanks