• Performance Issues with Custom Table Joins and Sorting in SugarCRM After MySQL Upgrade to 8.0.41

    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…

  • I was asked to create a report of all our SugarCRM reports and the number of times they have been accessed. Is this data even available with the Tracker module?

    We user SugarCRM Sell hosted in the cloud. When I perform a custom query like this: select * from tracker t where action = 'detailView' and module_name = 'Reports' order by date_modified desc The data exported just seems to be the date_modified…

  • Custom database manager

    Hi All, How can I created a custom database manager for MySQL. Is it supporting sugarcrm customization standards.