Title: implementation question and performance
Last modified: August 30, 2016

---

# implementation question and performance

 *  [alopeza](https://wordpress.org/support/users/alopeza/)
 * (@alopeza)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/implementation-question-and-performance/)
 * Hi Alex,
 * We are having a problem with the UAM plugin, hope you can help. We have
    Wordpress
   4.2.3 and the 1.2.6.6 version of UAM.
 * Users started claiming that they do not have permissions to see what they
    were
   expected to see.
 * We noted that their records at the wp_uam_accessgroup_to_object table were
    not
   there. If we re-create their records then the permissions works perfectly again.
 * As we didn´t remove that permissions and we have not idea about what was
    happening,
   we set up a trigger at that table to persist in another table any record that
   has been deleted. The trigger is:
 * CREATE TRIGGER my_trigger BEFORE DELETE ON wp_uam_accessgroup_to_object FOR
    
   > EACH ROW INSERT INTO wp_uam_accessgroup_to_object_AUDIT (object_id,object_type,
   group_id) VALUES (OLD.object_id,OLD.object_type,OLD.group_id);
 * Our wp_uam_accessgroup_to_object table has just 7000 records, but the
    wp_uam_accessgroup_to_object_AUDIT
   table grows insanely, up to 4 million rows and counting (all duplicates of the
   same records).
 * After digging deeper in the possible causes of the problem we noted that
    when
   a permission is changed from the WP interfase, the plugin deletes all the records
   and then recreates all the records again; we do not understand why this was implemented
   this way, but the trigger shows that.
 * In this single permission updates that deletes and re-builds the
    wp_uam_accessgroup_to_object
   table again and again we suspect that the causes of the problem are.
 * The questions are:
 *  – does this behavior make sense to you ?
    – do any other users report this same
   problem ? – can you help us solve this problem ?
 * Any hints will be greatly appreciated.
 * Thanks,
    Antonio
 * [https://wordpress.org/plugins/user-access-manager/](https://wordpress.org/plugins/user-access-manager/)

The topic ‘implementation question and performance’ is closed to new replies.

 * ![](https://ps.w.org/user-access-manager/assets/icon.svg?rev=1563783)
 * [User Access Manager](https://wordpress.org/plugins/user-access-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/user-access-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/user-access-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/user-access-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/user-access-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/user-access-manager/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [alopeza](https://wordpress.org/support/users/alopeza/)
 * Last activity: [10 years, 7 months ago](https://wordpress.org/support/topic/implementation-question-and-performance/)
 * Status: not resolved