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.