Hotaru vs pligg - taking into account server resources

[kameleon]

I need answer to one question:

I have few social bookmarking websites (3 of them have 100's visitors daily, and more then 100,000 bookmarks and several 10,000 users) based on the pligg platform. They are hosted on VPS hosting, but recently I have problems - they are taking too much resources (RAM memory) causing almost every day that VPS container turns off and that my site become unavailable for several hours or more.

One of hosting support admins tells me that pligg has bad optimisation (has a lot of MySQL queries, creates a lot of temporary tables), and recommends me to make transfer of my pligg sites to hotaru CMS. And tells me that hotaru is much better optimized and that takes much less server resources (RAM memory and other) - is it true?

thanks in advance

[hotaruuser]

I can just tell that I have to deal with 36mb memory limit on my site and it works really well and is really fast, but I have about 60 users and 500 posts, so not so much as you

[mabujo]

One of hosting support admins tells me that pligg has bad optimisation (has a lot of MySQL queries, creates a lot of temporary tables), and recommends me to make transfer of my pligg sites to hotaru CMS. And tells me that hotaru is much better optimized and that takes much less server resources (RAM memory and other) - is it true?

Short answer : yes.

Long answer : I have Hotaru installs that are handling millions of pageviews a month. I've done some custom work to Hotaru to handle load but mostly on plugins, the core is pretty good at db caching and caching some full pages.
The plugins that cause the most load are autoreader rss importing and tags + related posts.
It's of course important to have a decent VPS provider but you should be able to scale a typical Hotaru install to at least 150,000 visits/month on a mid-range VPS without much effort.