WordPress.org

1. xpose
   Member
   Posted 11 months ago #

   I've been keeping an eye on my mysql-slow-query log and noticed that there are some calls that could be indexed for better speed.

   For example: "SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';" This keeps appearing and there is no index to help speed this query up.

   I have two questions: 1) When I create custom indexes, will it break future upgrades? 2) Has anyone else created custom indexes for their WordPress installs?

2. apljdi
   Member
   Posted 11 months ago #

   1) Indexes shouldn't break anything. The worst that could happen that I can think of is that your index gets broken and you end up back where you are.
   2) Yes. Several. Never had a problem.

Reply

You must log in to post.