DevClub

Dev Answers & Best Practices What is the best practice to add a database index to a custom table?

Click here to join this group and curate your SugarClub experience.

Forums - Thread Details

State Not Answered
Replies 2 replies
Subscribers 320 subscribers
Views 156 views
Users 0 members are here

Forum Actions

Related

What is the best practice to add a database index to a custom table?

Acuitus 1 month ago

I want to add indexes to a custom table (to speed up reports) but is there an upgrade-safe (and rebuiild safe!) way to do this?

i.e. is there a way to add a php file to define the index?

Parents

0 Francesca Shiekh 1 month ago

You should be able to follow the same guidelines that are here, just use your custom module's module name:

https://support.sugarcrm.com/documentation/sugar_developer/sugar_developer_guide_13.0/data_framework/vardefs/working_with_indexes/

FrancescaS
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Acuitus 1 month ago in reply to Francesca Shiekh

Does this allow us to add an index to the _cstm table if the fields are in the _cstm table?

Or does this only allow us to add an index to the main table for the module?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Acuitus 1 month ago in reply to Francesca Shiekh

Does this allow us to add an index to the _cstm table if the fields are in the _cstm table?

Or does this only allow us to add an index to the main table for the module?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data