Jobroller dashboard - a monster eater resources
Hi
My all jobroller site is becoming very very slow and I'm on a optimized dedicated server.
Navigation in the site with a cache system is great, but whem you post 4 or 5 offers, minutes later site starts to hang and server goes down. And we are talking about a 20-30 users trafficc on a core 2 duo 2,2ghz server with 2gb DDR3 with just jobroller installed.
This happens without any active widget also, just wordpress + jobroller + jobright.
The wordpress dashboard, when editing offers some times take long to save them or edit.
I had times when I got 100users online with a cpu load of 0,22 and usage of 31% memory, wich is good but somehow any recruter starts doing a single post ou edit one post and the server goes down.
MySql and PHP are at optimal configuration to the server specifications.
I have 5.000+ users registered and 1100 offers (800 already expired)
Some weeks ago, when I tryed to access my jobroller user dashboard, it gave me an error of memory 287Mb exausted.... I had to raise PHP memory limit to 1024 (anything higher than 287 would be suficient) in order to show my panel with last posted job offers and statistics. And now that I can acces this page, it takes looooong time to load it, maybe because it consumes so much resources.
My thoughts is there are in jobroller some bad or unclean coding on sql querys, in this page and in others. In the next months, If I double the size of offers, I will need the double of ram to enter the dashboard... its insane. If 3 or 4 recruiters enter they're dashboard at the same time with this amount of offers, the site will take a dive.
Any thoughts on how to fix this?