I've developed a website in which I want to display posts 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 doesn't fit my needs).
My problem is that right now I'm 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 crashes the mySQL server.
So simply put right now the website is very very slow, and every 4-6 hours mySQL is crashed. How to improve the performance of this website?