I am going to create a web part that are going to replace an application that we currently are using. The application is basically used to query information from a database. The Database consist of less than 2000 items and the application those depending on the query show 10 - 500 items.
If possible I would like to use the same database as SharePoint is using since I know that the information then will be available whenever SharePoint is available. So is it possible to create my own tables within SharePoint.
My other thought is to use a SharePoint list, since again I do not have to care about availability. But this feel pretty bad since I it probably will be take up unecessary resources.
My third option is to use another database cluster within our network, but then the maintainability and dependencies are increased.
So how would you do, do you know any recommendations?