Everything working fine in external list. But when I open the list page each time in logs I am getting "This will likely result in significant performance degradation"

Question

Hi,

I created a BCS model using Visual Studio 2010 and from there I created a external list based on the model. Everything is working fine. Read Item is also working fine without any issue. But the problem here is each time when I open the external list a log is generating in the log file saying ..

"External Lists: Using default Filter settings for Finder 'ReadItem'in Entity 'BDCEntityName' of EntityNamespace 'BDC Model Name'. This will likely result in significant performance degradation."

I debugged the application also. No exceptions came. But don't know why this log is generating each time... :(

Please suggest me regarding this...

Thanks in advance !...

-

Rao

Answer 1

Hi Rao,

It seems that your external system has a lot of recored returned by BDC Model. You should always define filters (it can be limit/comparison/wildcard filter) so that you can narrow your search and overcome others restrictions regarding a count of rows in the database. Especially when working with high volume of items, there might be cases in which you may have millions of items to pick, bcs picker will show up to 200 items (this is SharePoint restriction).

Please take a look at these articles about filter creation:

• Creating Comparison and Wildcard Filters for BCS in SharePoint Designer 2010
• How to: Define Filters for External Item Picker Controls

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

Answer 2

Hi Dmitry,

Thanks you so much for you suggestion. Here my case is I created a BDC Model using Visual Studio 2010 and while accessing the records I already had given the filter condition. But as per your suggestion do I need to restrict the records up to 200 every time?

-

Rao.

Answer 3

Hi Rao,

You don't need. But if you are using BCS item picker it will show up to 200 items because this is SharePoint restriction. This is why you should use the filters.

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

Answer 4

Hi Dmitry,

If you don't mind can you please assist me on BCS item picker concept from Visual Studio 2010 point of view.

-

Rao

Answer 5

You should do nothing in Visual Studio. Just create a filter for your ECT. Take a look at this article How to: Define Filters for External Item Picker Controls

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

Answer 6

Hi Dmitry,

Today I tested my External list with few items. I mean to say my external list contains only four items in it. So now I checked the log file. Surprisingly I got the error saying that "External Lists: Using default Filter settings for Finder 'ReadItem'in Entity 'BDCEntityName' of EntityNamespace 'BDC Model Name'. This will likely result in significant performance degradation."

I don't know why this is happening for few items as well.

Could you please assist me on this ...

-

Rao.

Answer 7

How did you create your ECT? What external system are you connecting to? Does it really contain only four items?

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog