I have a large set of orders (about 7500) that I want to show in my SharePoint site. I'm using BCS because I also want to link the orders to documents.
I also have an external list with these orders, so that users can see the order data. The problem that I'm facing is that the external list itself loads too slow and if I want to filter in the list, the whole browser isn't responsive anymore. It loads all the 7500 records into memory.
Is there with BCS a way to load only 30 records, but still be able to filter on all records in the list? Or do I have to build my own webpart for doing this?