New MySQL Setup For Faster Query Processing
Two of the most frequent reasons a site might be slow are unoptimized PHP processes and heavy MySQL queries. Website code optimization is always a crucial part of the constant battle for more website speed. However, webmasters hosting with SiteGround, have always had a reliable ally by their side in this quest.
Recently we have announced the new Ultrafast PHP, which significantly speeds up the processing of PHP scripts and improve the website performance up to 30%.
As a natural next step in our efforts to offer a premium and superfast service, we deployed a server-side solution to optimise database queries which has already brought down the number of slow queries between 10 and 20 times!
What are slow MySQL queries and why they matter ?
If you are managing an active site with a database, you probably understand that when a visitor enters your site, there are tons of scripts that start running, some of which ask your database for information. For example, if you have an online shop and a visitor is trying to purchase an item, your store should check for its availability in the database and display if it’s possible to be ordered. That check triggers a MySQL query. And depending on how that query is written it may be quite heavy and time-consuming to be processed by the server. For you as a webmaster, these slow queries are a problem because you will be losing clients. You know how visitors drop out of the site when they have to wait longer than 2-3 seconds for a page to load? Well, you get it. For us as your host, we don’t like it when our servers get throttled processing too many slow queries because this means that the CPU and RAM of the machine get blocked and cannot be used for other processes, which are also important for yours and the other websites hosted on the server.