Search the Community
Showing results for tags 'slow query'.
Hello, I have been dealing with a performance crippling situation with X2CRM related to MySQL queries to the 'x2_trigger_logs' table. This manifests specifically whenever we interact with tags on records, such as adding a single tag to a contact. I wrote a simple PHP script that uses X2CRM's API to test performance of Create, Lookup, Update, Delete and saw the following poor performance: 08-11-2017 22:28:33.190000 Creating contact. 08-11-2017 22:28:34.310000 Done. 08-11-2017 22:28:34.310000 Lookup contact. 08-11-2017 22:28:34.360000 Done. 08-11-2017 22:28:34.360000 Adding tag to contact.