Sometimes the defaults that come with a product are exactly what you want. Other times they aren’t and you need to make a few changes. When it comes to MySQL, you’ll probably get along just fine if you never change a thing, but you can probably do better than the defaults with a few tweaks.
Tag: performance
An Introduction to MySQL Database Performance
It takes time to open a connection to a database, make a query, have the database find the requested data, and send it back to the file that made the request. That’s true even for very simple queries. The time depends on how the database is configured, the hardware on the server, how the data is stored in the tables being searched, and of course, how well the queries have been written.
Improve Your PHP Performance By Upgrading To PHP 7
When your phone starts to feel slow or you find your tablet or laptop taking a long time to perform some task, you start to think about upgrading. Odds are a newer device will come with better specs and a generally more performant device.
Tips for Writing Better Performing PHP Code
Should you use single quotes or double quotes when writing PHP? How about URLs? Should they be absolute or relative? You make choices like these when writing code and your choice will depend on a any number of factors, one of which is performance.
An Introduction To Performance And Dynamic Websites
A couple of weeks ago I shared some performance tests for server response time as well as Speed Index and time to first byte that I ran on this site before and after moving to a new web host. The posts were part of an on-again off-again series about website performance that I’ve been running the last year or so. In every post up to this point I’ve talked as though all sites were built in fundamentally the same way. As you know, not all sites are built in the same way.