Adding custom indexes to core wordpress tables

  • Resolved xpose

    (@xpose)


    13 years, 8 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?

Viewing 1 replies (of 1 total)

  • 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.

Viewing 1 replies (of 1 total)
  • The topic ‘Adding custom indexes to core wordpress tables’ is closed to new replies.