none
Sharepoint spgridview paging for list items with more than 20000 items RRS feed

  • Question

  • How to effectively do Sharepoint spgridview paging for list items with more than 20000 items.

    When we bind the list can we do rowlimit? but how then can we have 1,2, 4, 6... all on spgridview paging if we only do rowlimit as 100.

    We need good performance and also full paging on home page spgridview which displays completed proposals which may exceed 20000 items.

    We need one good sample to do paging 1,2, 4, 6... in spgridview with more than 20000 items in list.

    We do not want only previous/next using listitem position.

    If we use splistitemcollectionposition can we do paging 1,2, 4, 6...


    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead


    Tuesday, October 15, 2013 2:27 PM

All replies

  • Use paging with groups don't display all pages once for example if you use 10 items per page:

    Return top 201 items pges 1-->10 and next to next group (11-->20) and so on

    With the above return 200 items per group.

    This solve your problem of throttling and performance


    Tarek Yehia

    Tuesday, October 15, 2013 2:47 PM
  • Thanks Tarek.

    Can you give me some examples or links where this is implemented.

    I have landing page spgridview with list bound to it with 20000 items in that list and performance and paging with page numbers, sort, filter are major concerns.

    So i need

    SPGridview

    paging like 1-10  , 11- 20, 21- 30....

    and not next 10, previous 10


    MCTS Sharepoint 2010, MCAD dotnet, MCPDEA, SharePoint Lead


    Tuesday, October 15, 2013 4:49 PM