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?


BCS only returns about 2000 records per call maximum, if I'm not mistaken. It is also recomanded of course to have at least a Limit filter as well as include other filter into the "Read List" methods. Have a look at this step-by-step by Scott Hillier which highlights a simillar scenario:


| improve this answer | |
  • I've created my own .net assembly connector and with sql server profiler I see everything getting retrieved. The problem with the limit filter is that in the external list, I only can filter on the retrieved records. Is there a way to show filters that are executed on the database instead of in memory? – Marlou Aug 10 '12 at 12:44
  • I would go SQL Profiler as the tool to monitor/trace calls – Marius Constantinescu - MVP Aug 10 '12 at 13:30

I ended up creating my own webpart to do this :-(

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.