Pagination and Best way for Optimization of data load

[eluser][email protected][/eluser]
Hello, CI Pros:

I wonder what is the best way to paginate large tables? Will the pagination class in CI enough for large data load from mySQL by multiple users at the same time?

For example, 100 users load a table with 100000 rows at the same time.

how can I load only, for example, 100 pages at a time? Or is the jQuery's loading everything then hide and make data "appears like" in pages is a better solution?

Thank you!