I have built a REST based API (using asp.net WebAPI) which returns RSS feeds to my mobile application. There are around 30,000 active users of my mobile application which access this RSS feed. As per Google analytics, there are around 500 users using the REST API any point of time. I expect this number to grow over the period of time.
To improve the performance of the API, i cache the RSS feed in memory so that subsequent requests are served from memory only. The cache is refreshed every 3 hours.
Question: Given that most of the action is happening in memory, do i need to get a VPS hosting with SSD or a normal HDD (RAID 10) will suffice ?
EDIT: Using Windows Server 2012 R2 softsyshosting