SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In my company a person which are Administraiting the CRM Microsoft Dinamics give me one of External list with a Vacation of Workers in Company. I try first with list local in my project, and this list work and refresh after one secounds, and have got 1024 eements. I try conect with my proyect a External List from CRM and its take a ot of time because it's take about after conect this list with my project 60 secounds. It's more approximately 60 times then in the first time. How should I make it faster, and upgrade the performance of my project. Please Help

share|improve this question

The first thing I'd suggest is to implement paging in your BCS Selectors, as by default the Selector will be getting all elements every time the list is refreshed - and it doesn't cache at all - which is a bit of a shame, but makes sense when you think about it.

This will give you the most immediate benefit. Take a look at this question about External List paging on this site to give some details on how to do this.

After that is done, then you'll need to look more deeply into optimising what you've done. But, this single thing should give you a big improvement.

share|improve this answer
But I must told I rendering this On ASP Calendar at method Calendar1_DayRender. I must ask how should I give a paging to ASP Calendar render? Have You got any Idea ? :) Thank You very much that fast replay :) – Grzegorz Z Dec 10 '12 at 9:16
If that's the case, then I'd suggest adding a filter method to the external entity of Date or some such, so that it only returns results for that day, rather than all events and then filtering them as I'm guessing it does at the moment. – TZHX Dec 10 '12 at 11:59
Maybe the dates on this month, which are selected on Calendar, but how take Entity from External List imported from CRM, and how eit Entity. I don't see after adding to project BBC Model -> BCS Meta Man Data Explorer – Grzegorz Z Dec 10 '12 at 12:25
I don't use BCS Meta Man, so I'm afraid I can't help you with that. – TZHX Dec 10 '12 at 12:30
Ok thanks. :) :) – Grzegorz Z Dec 10 '12 at 12:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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