GridView pagination performance

Question

Let's say I have a GridView with 1.000 rows. And I don't want any pagination and have all the rows visible. I can do two things:

Set AllowPaging="false" (most logical)

Or

Set AllowPaging="true" and with a higher PageSize than the total rows: PageSize="9999"

So my question is if there is any significant difference in performance between both options and if so, how do you measure something like that.

Answer 1

I have been working for more than 4 years as web developer specifically asp.net developer. I have widely used datatables.net. It is very powerful,rich of features and evry easy to use.

If your gridview has 250 rows max datatable can easily digest 250 rows. I would recommed you to load 250 rows initially and when user change number of rows you can simply set option of datatable to show that many records.

Once your gridview has loaded you can apply datatable to it.Here is a little example. here is jsfiddle

You need to set 'pageLength': 25 property to decide how many records to display. initially set it to 250 after user will change the option no server side call will be sent.

And use 'lengthMenu' option to show number of records to show.

$("#tblInfo").dataTable({
            'pageLength': 25,
            'lengthMenu': [[10, 25, 50, 100, 150, 200, 250], [10, 25, 50, 100, 150, 200, 250]]
        });