Adding indexes to _cstm tables

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.

We examine a number of different options that we could use to add an index.

• I could add a post-install function as part of the module loadable process.
• I could use the extension framework to add the index when a Repair and Rebuild is run to check the index.

Loading ....