WordPress Database Index Performance Test

WordPress Database Index Performance Test

I like to work on database optimization every now and then, so I wanted to take a look at creating an INDEX for the wordpress database.

In the graphic below we see the starting point:

After I created an INDEX for each of the tables in the WordPress database, the result changed as follows:

Of course, I then reset the database and tested it again:

It should therefore be noted that, at least in my case, there was even a deterioration.

With extremely large databases, however, the page load time could still decrease.

Leave a Reply

Your email address will not be published. Required fields are marked *