Hi All

We are currently fetching data in order of 1 million items from SQL server as external list. The requirement is to crawl and display the data in search results. Is there an option (without changing the throttle limit) to be able to fetch records greater than threshold limit defined

Vijay

Hi Vijay,

If you don't want to change the throttle limit, as a workaround, we can create a SQL stored procedure to do the Read List operation, rather than querying the data directly.

Here is a blog for your reference:

A step by step guide in designing BCS entities by using a SQL stored procedure

http://blogs.msdn.com/b/jysaikia/archive/2010/12/15/a-step-by-step-guide-in-designing-bcs-entities-by-using-a-sql-stored-procedure.aspx#Create

Best Regards,

Dennis Guo