• 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…
  • Queries getting stuck on 'creating sort index', slowing Sugar down.

    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…