Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am designing a system and considering using an InfoPath form to store data in a SharePoint list.

I am wondering if there is a limit to the number of rows in a SharePoint List?

Would a better solution be to store the data in a SQL Server table and retreive the data via BCS?

share|improve this question

3 Answers 3

up vote 2 down vote accepted

Lists capasity is near 30,000,000 items so I think it would be enouf for you and you don't need to use SQL Server table. For more information follow this link - Sharepoint Limits

share|improve this answer

It all depends, like everything SharePoint. What version are you running? What are the use cases once the content is stored?

share|improve this answer

30,000,000 items are all in all. Theres also a soft limit of 5,000 per view or folder where performance will degrade. A list could also be partitioned using meta data navigation with managed meta data / taxonomies.

If you plan to use the data in a relational way, SQL server is a good choice. But since you talk about storing infopath documents it seems obvious to use one or more document libraries with appropriate meta data and views.

Also remember that for large lists you have data throtling, so keep that in mind if you plan on retrieving data from the list programmatically.

share|improve this answer

Your Answer

 
discard

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.