I have an on premise SharePoint 2010 implementation. I need to implement a custom form with 65 fields which has rich text, drop downs and some complex filtering logic on the form. I want to load the form in 5 seconds.
The custom form could potentially save data upto 1 million records. I am planning to store the data(i.e. 1 million records)in a SQL server. I am planning to use BCS to extract the data from SQL server and surface them in SharePoint.
I am planning to build a Custom SharePoint Web part to surface show data in SharePoint. The form has around 65 fields and I want to load the form in less than 5 seconds.
I have the following queries
Does External lists have the same limitation's of custom lists i.e. 5,000 items throttling limit. Does increasing Throttling limit resolve the issue.
IS there a better architecture so that there is no bottle neck for the form with 65 fields to load when the items in the external list increases more than 5,000 i.e. reaches 1 million.