I've developed a website in which i want to display post's from RSS feeds from other websites. i've used wordpress ofc and after lots of trial and error with RSS importers i found that Multi-Importer plugin does exactly what i need (no autoblogged doesnt fit my needs).
My problem is that right now im importing feeds from 130 RSS feeds, and the server runs out of memory and website is lagging like hell. I moved the website into a new VPS with 4 cores and 8GB of RAM, and each time it checks for new RSS it takes up all the RAM and every 6 hours it craches the mySQL server.
My plan is to make a website with constand flow of news gathered from other websites, but im getting fraustrated because it has made my website very slow.
Im considering now to move this website into a dedicated server with 16GB of RAM or more, if it is to solve my issue because i want to have a total of 300-500 RSS feeds to run constantly (every 10min is the minimum in multi importer).
Any ideas or suggestions how to improve this project?
Thank you in advance for your time.