I was so pissed with the WordPress 2.7 blogs I host with Bluehost on shared hosting. I do not have problems with my main blogs which is hosted on the VPS server.
So, I shoot a complaint to them through their support ticket. I got a mail that goes, “Dear Customer, It came up pretty quick for me. I checked the server and everything looks good. ”
I guess Bluehost must have a million complaints and they have gotten defensive when we blame the slow speed on their hosting. In turn, they blame our php codes. Being a noob, I do not have much choice so I just followed these steps they gave me to overcome the slow WordPress 2.7 speed :
Just follow these steps: (Note: It is always a good idea to back up your database before making any changes)
1. Log into your cpanel.
2. Click on phpMyAdmin.
3. On the left will be a list of your databases. Select the one you want to repair/optimize.
4. This will load all of the tables in your database into the right side. At the bottom of this list, there is a link called “Check All”. Click that.
5. Just to the right of the check all link there is a drop down menu that says “With Selected.” Click on that, and choose “repair”.
6. You should get a page that will list all the tables, with “OK” listed next to them. When this is done, look up to the top of the page, and click on the “Structure” tab.
7. This will take you back to the page you saw on step 4.
8. Click “Check All” again, and then choose “Optimize” in the drop down menu.
You should see the same page as in step 6. You’re done!
Many weird MySQL errors can be fixed by this process. I suggest doing these steps frequently to keep your database in good condition.!
I did the above and the speed of my Dashboard loading is a little bit faster now.
So, if you have WordPress 2.7 that takes forever to load, then, you may want to try this.
I don’t guarantee it works for you though.
Calvin Ngan(January 13, 2009 - 3:26 am)
Do you know Lester Chan has this plugin called WP-DB Manager. It does exactly what you mentioned earlier, simply activate the plugin and manage your mysql directly in your wordpress… plus, the user interface is much easier to understand.
Manages your WordPress database. Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up and optimizing of database.
Bryan(January 13, 2009 - 8:54 am)
Yea, I also optimized mine. Since upgraded to WP2.7 I deleted a lot of old data left by deactivated plugins.
Anyway, just remember to make database backup before touching databases because mostly if anything wrong happens it’s not reversible. :)
email2me(January 13, 2009 - 12:45 pm)
I’ve downgraded my WP to 2.6.5. They suspend my account just for that. Ask me change theme.
The speed of my blog now is much much faster compared to WP 2.7
I don’t feel safe with the 2.7. You won’t know when something will be screw up again. Let us wait for 2.8 and then only upgrade.
Jys(January 13, 2009 - 1:53 pm)
hmm, i’m using wordpress 2.7 and hosted on bluehost. really should try this to speed up..
Calvin Ngan(January 13, 2009 - 2:26 pm)
@email2me – Which hosting provider are you with?
@5xmom – try mediatemple.com, they’re awesome!
Abhisha(January 13, 2009 - 9:03 pm)
Ye dudes, i ma dba user and found great tool sqlyog where its become friend of mine. Gui is improved and also too friendly to use. Easy installation its not tiring like phpmyadmin copying files here and there. I can say dba users surprise gift.
James Wilson(January 13, 2009 - 9:42 pm)
Thanks for posting your links, this will surely help me a lot. I donâ€™t have to spend time looking for the good sites, youâ€™ve already done that for me.
Andrew Ooi(January 14, 2009 - 12:20 pm)
Sometimes it’s also geographical. For example my main website gilachess.com always loads fast when I browse it. However, when I went to Vietnam and Philippines it took forever to load. That website is run on Exabytes, a local host.
My GoDaddy hosted website are the opposite. They seem to load slower in Malaysia but outside of Malaysia they are quite fast.
It’s irritating I know but I’m betting when Bluehost support replied you they really loaded the page faster compared to you in Malaysia. Just my 2 cents..
Calvin Ngan(January 15, 2009 - 4:11 am)
yup, agree with Andrew Ooi. When I was studying in Australia, everything appears to be flying at lightning speed, reality took hold of me when I am back in good old Malaysia… it took me 1 minute to load my admin page in wordpress hosted in godaddy.
streamyx’s, celcom3g’s fault… end of the day, it is our BN gov’s fault for allowing telekom to monopoly the last mile.