New db index added by plugin on core tables

[blog.brockha.us]

I would like to count comments by a single commenter in my blog. For that I would count comment emails. I will need an index to do that in a performant way.

What do you think? Is it okay, if plugins add indexes to core tables? And if yes, should they remove the index on uninstall?

Thanks for input.

[garvinhicking]

Hi!

I wouldn't mind a plugin doing that, this won't really hurt. I wouldn't remove the index after uninstalling because of the same reasoning.

The only thing the plugin could IMHO check (using the given SQL syntax, since mysql and pgsql and sqlite AFAIK differ for this) is if the index already exists, so that it doesn't get added multiple times.

Regards,
Garvin

[blog.brockha.us]

Okay. Thanks for the input, Garvin.

About removing the index: I was a little worried about unnecessary performance slow down while inserting. On the other hand: If another plugin relies on the same index, it would be nasty to remove it while uninstalling.

(Are you back? And already in this forum again? You are my Jungle King )