Today I’m going to take things off topic a bit and share my latest experience with our website issues. Lately, Google has been saying that website speed is going to be considered a factor in their search algorithm. So I thought I would do a speed test on our site to see how we compared to the big players. I started to look more into the issue when we noticed that our site wasn’t the most stable. As time went on, it was getting to the point where this site would actually crash for a few minutes every time we tried to edit a post. So when we received a media mention from the Globe and Mail last week I was pretty nervous that we would crash due to the increased traffic!
Speed Test Your Website With Google
As it turns out, I shouldn’t have done anything because the results were pretty terrible and we needed to take some big steps in order to improve. According to Google Speed Test we were anywhere between a 74-79 depending on the time of day. With our site being so unstable I was beginning to wonder if a full moon had anything to do with it. As I dove deeper into the issue I found there were a number of things wrong and went about making things right.
From the speed test sites I was able to get a good handle on what the issues were and was able to get some guidance on how to correct them. So we did the basic stuff
- Installed Caching
- Decreased the size of all of our pictures
- Installed Cloudflare (use a CDN)
- Removed unnecessary plugins
- Deleted Themes that we weren’t using
- Optimized Database………..Here is where I found my 2 week headache.
WordPress Databases Will Skew Your Speed Test
Despite what Teacher Man thinks of my technical abilities, I can’t do any serious coding. I can use WordPress pretty good, but as soon as I see more than 3 lines of HTML code I get confused pretty easily. With that said, I’m still light years ahead of him ;). When WordPress databases came into the picture I was immediately lost in the thousands of lines of code and tables.
On every website I found on speeding up your website, they all mention the basic stuff that fixes 80% of the problem, speeds up the site by 80%, but for us it was something a little out of the ordinary.
To break it down, whenever you leave your WordPress post open for editing it will create an auto-save every few minutes. Each time it saves, it generates a new copy; thus a new line of code in your database. After editing 200+ posts it tends to fill the data base up with garbage that you don’t need slowing down your site.
Another annoying thing is each and every plugin you install will leave most of its settings in the database, even if you uninstall them. I’m pretty sure this applies to themes as well and when we first started out we were playing with quite a few of them. What is worse is that I sampled hundreds of plugins and throughout the whole thing I never backed up anything!
I Have A Newfound Respect For Web Designers
So after over a year of leaving posts open and sampling different themes and plugins (and whatever else we’re doing wrong and we aren’t aware of ) it was time to do something about it. Since I’m not a coding expert and didn’t have the desire to learn it, or stare at lines of code for days on end, I thought I would try to start fresh and delete the entire site (including the database) and start over.
That’s when I learned that all 200+ posts and pages were stored in the database. After long talks with my host (BlueHost) we were able to determine that they couldn’t do anything to help me out. To be fair, it wasn’t exactly their problem and that I was to consult my webmaster…who was unfortunately…yours truly.
I figured that I would try a long shot and after testing it on other sites…. I figured it was time to take a gamble. By using the export function in your tools tab in the wordpress dashboard I exported all of my content and saved it/emailed it/burned it on a cd/saved it on a USB stick. Once finished, I wiped absolutely everything and re-installed word press again and started out fresh.
I installed my theme, necessary plugins, and uploaded my content and with a few tweaks, the site is running faster than ever. On top of that, I can edit this post without our site crashing!
In Closing…
Nowthat you have read my story, I want to summarize what to take away from my rant so you don’t make the same “rookie” mistakes I made
- Backup your site often – you can never have too many backups
- Don’t install plugins willy nilly because they look cool
- If a plugin is version 1.0 it means it is on its first trial run and it will probably be coded poorly; consequently it is likely toslowdown your site
- Run a speed test to see how you can improve your website
- Optimize your database regularly to get rid of the overhead (ie: dead weight)
- Check out Cloudflare and see if its right for you -Its pretty easy to set up and adds security to your site
Places you can speed test your site
There are more, but the first 2 options give you way more information than you can handle. Pingdom conducts its speed test from different parts of the world. If you sign up for an account, it will test your site every minute and it will even notify you via email or text if your site is ever down. GT Metrix is similar to Google and it gives you a detailed “waterfall” description on how each part of your site loads. It is a great speed test tool because it gives detailed instructions so you can take steps to make your site load faster.
Since I know a few of our readers have their own websites I’ll make a post later on highlighting which plugins we use. After trying out as many as I did I feel my experience might help a few people ;)
If anyone has any questions or issues with their site comment below and I’ll try to help if I ran across similar issues.