59 pointsSerious WPMU DEV-sterI'm new here
philesq
Member
—
9th February 2012 (3 months ago)
My hosting company Site5.com is giving me a problem about using too much CPU time. Will Multi-DB set up for 16 databases decrease my CPU usage? I currently have 291 subsites set up and could eventually grow to 1000+.
My hosting company Site5.com is giving me a problem about using too much CPU time. Will Multi-DB set up for 16 databases decrease my CPU usage? I currently have 291 subsites set up and could eventually grow to 1000+.
5605 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Support Kangaroo
—
9th February 2012 (3 months ago)
#
Greetings philesq,
My hosting company Site5.com is giving me a problem about using too much CPU time. Will Multi-DB set up for 16 databases decrease my CPU usage? I currently have 291 subsites set up and could eventually grow to 1000+.
Yes it will help with CPU usage to a limited degree. Right now with one database when someone accesses one of the web sites CPU time is required to parse through the entire database searching for the items that it needs to fill the php page requests.
When you employ Multi-DB it will spread the sites data throughout several databases making data seek time much less and therefore CPU time less to include being easier for the CPU to parse.
Another suggestion would be to use a caching program if you are not already employing one which will help with the PHP calls further cutting down on CPU time and power required to fulfill requests.
Have you tried the WP Super Cache plugin? That could definitely do the job for you - I would love to hear how it goes if you try it out?
If we can be of further assistance please let us know.
I'm using WP Super Cache now but they said I'm still using too much CPU time. Also, with WP Super Cache, new content on subsites is not showing even after several days and using a different browser. I'm trying to figure out why the content is not updated.
I think I would prefer to have someone set up Multi-DB for me. Do you do that?
Responses (2)
Support Kangaroo — 9th February 2012 (3 months ago) #
Greetings philesq,
Yes it will help with CPU usage to a limited degree. Right now with one database when someone accesses one of the web sites CPU time is required to parse through the entire database searching for the items that it needs to fill the php page requests.
When you employ Multi-DB it will spread the sites data throughout several databases making data seek time much less and therefore CPU time less to include being easier for the CPU to parse.
Another suggestion would be to use a caching program if you are not already employing one which will help with the PHP calls further cutting down on CPU time and power required to fulfill requests.
Have you tried the WP Super Cache plugin? That could definitely do the job for you - I would love to hear how it goes if you try it out?
If we can be of further assistance please let us know.
Cheers, Joe :-)
Member — 9th February 2012 (3 months ago) #
I'm using WP Super Cache now but they said I'm still using too much CPU time. Also, with WP Super Cache, new content on subsites is not showing even after several days and using a different browser. I'm trying to figure out why the content is not updated.
I think I would prefer to have someone set up Multi-DB for me. Do you do that?
Become a member