CiviCRM Community Forums (archive)

I've been running some queries against participant_payment table to check out some integrity issues & they are dog slow so I took a look at the indexes. There is an index for participant_id & one for combined participant_id / contribution_id but not one just for contribution_id - hence the slowness given that I'm querying against the contribution table. Would this slowness affect civi usage or only my artificial scenario?


   Keyname   Type   Unique   Packed   Field   Cardinality   Collation   Null   Comment
   PRIMARY   BTREE   Yes   No   id   0   A      
    UI_contribution_participant   BTREE   Yes   No   contribution_id   
                                                                                  0   A participant_id   0   A   
   FK_civicrm_participant_payment_participant_id   BTREE   No   No   participant_id   0   A