WordPress is the most popular CMS used by many websites; it is written in PHP which makes it an ideal choice for most people. It offers a lot of features and an easy to use backend.
But it performs well until the MySQL database is small and your WordPress setup does not live on too many plugins and has permalinks set correctly.
WordPress on a small Web Server cannot handle many visitors and might fail due to MySQL database crashing which at time can be a big problem, it can occur due to lack of free memory, if there are other things that use the MySQL database it will make WordPress slow if the website get a lot of traffic.
So, I decided to write a simple post, which will let you run WordPress on a small Web Server with optimum performance.
It is recommended that you do this in a clean WordPress setup and then migrate content to the newer install rather than tweaking the current WordPress install that is running in production, It is also better to test the environment before switching it to production, because there are many factors that can make a positive or negative performance difference.
Let's do it!
We will use SQLite instead of MySQL, this is recommended if the website is just a blog or does not serve or receive thousands of requests at a time, I have not tested this in high traffic, but has been rock solid stable on the amount of views I get for my website.
You can follow this guide to install and setup WordPress with Sqlite.