Earlier this week, I ran into an issue where I needed to add an index on a SugarCRM custom table. One of our clients was running into a performance issue, searching on a custom field that was added via Studio. When I was testing the issue, with a small set of data I was unable duplicate the problem, however the client has more than 1 million rows in the table. The search was doing a full table scan and the solution would be to add an index on the field.
I am unable to access the database directly, so I needed was to added an index to the custom table. I examined the different choices. One of my mantra’s with working with SugarCRM is NoSQL use the framework to do all database work for you.