Just saw this in phpMyAdmin and figured it would be worth mentioning.

Problems with indexes of table `openlayers_layers`
Problems with indexes of table `openlayers_styles`

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

zzolo’s picture

Title: The indexes PRIMARY and name seem to be equal and one of them could possibly be removed. » Redundant indexes on Styles and Layers tables
Version: 7.x-3.x-dev » 7.x-2.x-dev
Category: bug » task

Thanks, @mgifford. This is redundant. But it will need an update function to go with it, so not making it a priority at the moment.

mgifford’s picture

Yup.. Just as a todo for the next release point or something. It might have a small performance impact, but other than that.

ekes’s picture

Status: Active » Needs review
FileSize
983 bytes

Small patch to do this.

mgifford’s picture

Version: 7.x-2.x-dev » 7.x-3.x-dev
FileSize
1.02 KB

Looks good. I just did a fresh install from the git repo 7.x-3.x and it worked. I reworked this patch so it can be applied with git rather than patch.

Pol’s picture

Status: Needs review » Fixed

Thanks @ekes & @mgifford, committed to 7.x-2.x & 7.x-3.x ;-)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.