abuse_status table has no index defined.

Comments

jaydub’s picture

jaydub commented

I going over this module now and have a few thoughts on indexes as well. I will post my summary of suggested indexes...

jaydub’s picture

jaydub commented

I created a bunch of dummy content and went over the queries in this module. I think that there is a place for 2 indexes that appear to cover every query of those tables in the module currently.

{abuse} table
multi-column index on (oid, type, uid)

{abuse_status} table
multi-column index on (status, oid, type)

I'll consider writing up a hook_update for the .install file if anyone can check my suggested indexes and let me know if they are sane.

jaydub’s picture

jaydub commented
Assigned: Unassigned » jaydub