7

I need to devise a solution strategy for an internal application that will take inputs from rfid tags and those records will to be stored "somewhere". Now this somewhere needs to be choice a between a SharePoint List or a SQL Database. High volume transactions are expected on this.

Reports and views will be created for the concerned stakeholders on these recorded transactions depending on the required business logic. While, SharePoint is the obvious choice for the presentation layer , considering the plethora of options I get using list views , content query , reports and performance point dashboards and I am still unclear about using a list to save the data or use SQL Database.

By high volume I am expecting around 20k new items/day.

Improve this question

3 Answers 3

Reset to default
8

I'd go for the SQL database. For several reasons:

  1. Storing into SharePoint list adds a lot of overhead that you don't need.
  2. With 20K items per day you'll reach the supported max in 15000 days and list throtling limit in 6 hours
  3. But most important with that amount of data what you want to get out is aggregate to make sense of the data. And this is the area where SharePoint really is lacking compared to SQL
Improve this answer
1
  • I would also go with the SQL database option. You can always pull that data into SP using BCS and External Content Types. Commented Oct 16, 2012 at 20:18
5

I would, and have in the past, use a separate SQL database to store all of that data. This will require additional work for the presentation of the data, but using BCS, SSRS and/or PowerPivot, you can pretty easily pull that into SharePoint. I wouldn't put that much into a SP content database and expect good things ;)

Improve this answer
0

It seems that you are planning to develop kind of a 'service' here.

I don't think list is an option, however you could develop this as custom service application that will still be part of the SharePoint infrastructure but underneath it will utilize service database.

ParagoService is a good example of custom SharePoint service application implementation

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.