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
Use JQuery paging with list view web part.List view web part is used for populating data from sharepoint content database