We have a SharePoint application developed in SharePoint 2013 for a hospital and the application has around 10k transactions/day.
I understand that Sharepoint is not a good candidate for transactional systems and there might be real need to migrate the application to more native web application with relevant database.
Some of the lists in this application have around 1 million items and there are a lot of relations between the tables.
My questions are
Is there a limit of transactions handled by Sharepoint?
How badly will the performance be affected if transactions are increased?
Is migrating the system to other platforms good in a long run?
Appreciate any suggestions and advice.