We recently upgraded MySQL from version 5.7 to 8.0.41. Post-upgrade, we have observed a noticeable improvement in overall query performance. However, we are encountering a significant performance issue, specifically when accessing list views in modules…

Hi All, Kindly suggest how to add condition in custom report query where clause to get records created in Last Quarter? Thanks, Shreya

The DBManager - http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.7/Data_Framework/Database/DBManagerFac… - is indispensable for querying the database. My favorite way of preventing SQL injection is binding variables, so…

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…

If any additional information is needed that would help you solve the problem, just let me know. I'm running SugarCRM 6.5.20 CE I have a logic hook that fires for a custom module and when I go to check the log, the query shows an execution time and appears…

Hello Developers, I wrote a simple function that open a leads csv file and insert them into sugarcrm. there are 100,000 Leads in the file. and i loop through each row (using fget()) and create the lead bean and save() it works perfect! but as soon as…