We have a requirement which is a kind of request and approval application which is for different set of countries. Total number of requests for all the countries sum up to 1500. So for approval history and all i would expect 1500* 7 ~11500 per month records in history list. I have some questions
Is it a good idea to prefer SharePoint or SQL?
In SharePoint is it better to store all the requests in one list differentiated by country codes or separate lists for each country?
I guess in SharePoint I should be thinking of an option to archive as well. So if I am archiving how should I be showing it in search results assuming that I implement C# code to bring and show the results in custom grid?
Insights on the above and any suggests will be helpful or share experiences if you have implemented any architecture of this sort.