Title: Performance Issue
Last modified: November 4, 2021

---

# Performance Issue

 *  Resolved [scottm1967](https://wordpress.org/support/users/scottm1967/)
 * (@scottm1967)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/performance-issue-38/)
 * We are having periodic spikes in load on the server. It seems like the query 
   to update the API last access time for CC is one of the big offenders. It looks
   like this query is executed multiple times in rapid succession causing locking
   issues with mysql. I can see in the logs that it is executed just seconds apart.
   The query is:
 * UPDATE `woocommerce_api_keys` SET `last_access` = ‘2021-11-04 00:06:36’ WHERE`
   key_id` = 19;
 * The entry for 19 is Constant Contact.
 * Please research and fix.

Viewing 1 replies (of 1 total)

 *  Plugin Author [Constant Contact](https://wordpress.org/support/users/constantcontact/)
 * (@constantcontact)
 * [4 years, 7 months ago](https://wordpress.org/support/topic/performance-issue-38/#post-15036838)
 * Hi [@scottm1967](https://wordpress.org/support/users/scottm1967/)
 * Do you have any other Constant Contact based plugins installed or plugins that
   have their own Constant Contact integrations?
 * Asking because I’ve checked the plugin’s code and I’m finding a place where potentially
   remove a woocommerce_api_keys value, and where we select found keys from the 
   database, but none where we’re updating anything around last_access. It’s possible
   that that part is coming from WooCommerce, and it just happens to be causing 
   some slowdown when managing the key(s) for our plugin.

Viewing 1 replies (of 1 total)

The topic ‘Performance Issue’ is closed to new replies.

 * ![](https://ps.w.org/constant-contact-woocommerce/assets/icon-256x256.png?rev
   =2984003)
 * [Constant Contact + WooCommerce](https://wordpress.org/plugins/constant-contact-woocommerce/)
 * [Support Threads](https://wordpress.org/support/plugin/constant-contact-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/constant-contact-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/constant-contact-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/constant-contact-woocommerce/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Constant Contact](https://wordpress.org/support/users/constantcontact/)
 * Last activity: [4 years, 7 months ago](https://wordpress.org/support/topic/performance-issue-38/#post-15036838)
 * Status: resolved