What are the best practices in pagination? : <p>Im doing a MVC web project in .NET, and kind of thinking best way to show a list and pagination. I have 3 options </p>

<ol>
<li>I can show the table using Jquery Tables(Data Table JS).</li>
<li>I can use MVC pagination.</li>
<li>Manually handling pagination using a SP.</li>
</ol>

<p>Option 1 will fetch all data at once using a AJAX, and table js will handle paging itself. We don't have to worry about paging,but if it's a huge data set to handle will it wise to have this ???, because every time it will load all the data.</p>

<p>Option 2 will get only the data which will need to show (Set by set), but each time a request may be triggered to the server side.(This will manage the pagination in controller level IPagedList)</p>

<p>Option 3 also will fetch only the data we need from the database level. Same as option 2 will const server request for each page changes.</p>

<p>So what would be the best option, we have to think about two scenarios may be. That will be if it is big data set and if it is small data set.</p>

<p>What are the best ways of doing this? Appreciate any explanation ?</p>
