Optimizing MySQL: Queries and Indexes Article 3 of 4

Optimizing MySQL: Queries and Indexes Article 3 of 4Courtesy of: Ian Gilfillan Ordering by surname is a common requirement, so it would make sense to create an index on surname. But in this example our employee table consists of thousands of people from Swaziland, and with the surname “Dlamini”. So we need to index on…

Optimizing WordPress

WordPress is currently one of the most popular blogging/CMS applications. Here are some ideas for optimizing WordPress and reducing the CPU consumption of this PHP script. Make a backup of your account first, and then upgrade to the latest version of WordPress. The latest versions have optimized code that could reduce the CPU consumption of…

Optimizing MySQL: Queries and Indexes Article 1 of 4

Summary This series of four articles will demonstrate how to optimize your MySQL Databases. These articles have been provided courtesy of Ian Gilfillan Optimizing MySQL: Queries and Indexes – Page 1 More on Indexes – Page 2 Leftmost Prefixing – Page 3 Optimizing Inserts – Page 4 Optimizing MySQL: Queries and Indexes Article 1 of…

My Website Is Slow

Having a slow loading website can be frustrating, and can lead to less traffic visiting your site. If your site relies heavily on e-commerce or advertisements this could result in substantially less revenue being generated by your website.There are many reasons a website may be slow. A huge spike in Additional Traffic. A Dynamic Site…