Hey! A client of ours is experiencing some weird slowness issue in Sugar 7.9 running on MySQL 5.7. The problem is caused by some of the sql queries taking an extremely long time which effectively causes many of them to get stacked. This in turn eats up…

I have a query that is repeated regularly and is pretty heavy on the database: SELECT COUNT ( id ) AS count FROM contacts WHERE team_set_id = '1' AND deleted = 0 AND id != '62f0e518-5d7e-8e98-f809-58d3bd75e98c' The contact ID parameter changes, as does…

I created a namespaced before_save logic hook that queries the DB for the largest number in a custom field, increments the result and sets that on the record when a new opportunity is created. It works perfectly on On-Premise, but responds with an Error…