BDC Paging

Question

I’m using SharePoint (Business Data List web part) with the BDC. I use this to bring back data from the database, nice and simple.

However, when I do a search I receive a number of results being paged by the web page. This takes a while to bring back any search results (even when navigating between the paged data). I’m guessing (please forgive my ignorance) that all the results are returned and the paging is done on the SharePoint server, not at the SQL level. Can we do SQL paging for example SQL Paging

Please can someone shed some light on this?

Kind regards Bones

Answer 1

Use JQuery paging with list view web part.List view web part is used for populating data from sharepoint content database

Answer 2

Are you sure that is brings back ALL the data. That's really not how I saw it working. See here and here.