Hi there,
Greetings for the day.
I am a ASP.net, MVC developer with 7+ years of development experience.
I have been developing MVC applications from pas 4 years and have worked on variety of projects. Please check out my profile page.
I have already worked on the same situation many times common approach is table partitioning; but we can discuss about other options too according to your requirements.
I have worked on variety of technologies including C#, asp.net, mvc, javascript, xml, jquery, html/html5, xml, winforms, wpf, web service, wcf, Restful/webapi, multiple payment gateways including paypal, multiple third party apis integration and apis development for web and mobile applications.
I would like to help you in your endeavor.
Thank you.