Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I've some specific use case for certain default wordrpess tables, which I need to add a few indexes to certain columns to improve performance. I'm wondering will adding these indexes break future Wordpress update when they choose to add index to the same column?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Adding a BTREE or HASH index shouldn't break anything, and I imagine that is what you want. At worst you could end up with multiple indexes, or less than optimal ones, which might negatively effect performance. I assume that if you are going to do this you will be evaluating the change to see if it actually does help, rather than hurt.

I guess you could run into trouble with a UNIQUE index, since WordPress does use a couple of those.

share|improve this answer
    
Yes, I've evaluated the changes in dev. Now I'm planning to push to production. So Wordpress will actually skip on duplicate index when it update? I'm worried that it will break the update and becoming hard to trace later on –  faulty Dec 4 '12 at 5:41
1  
It isn't without some risk but nothing critical should depend on an index. –  s_ha_dum Dec 4 '12 at 5:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.