LinkBack URL
About LinkBacksHi,
I have several custom fields and I would like to create some indexes to my installation faster. How do I have to create those indexes? What names do I have to give them and what columns do I have to chose?
Andreas
Senior Member
How to find out which indexed to create in database for custom fields?
Hi,
I have several custom fields and I would like to create some indexes to my installation faster. How do I have to create those indexes? What names do I have to give them and what columns do I have to chose?
Andreas
Sugar Community Member
Re: How to find out which indexed to create in database for custom fields?
You should first enable the option to log slow queries and interact with the system.
That will generate a log file with queries that are not running as efficiently as they could be. You can then use those queries in combination with EXPLAIN and ANALYZE TABLE to dig deeper into what can be optimized.
Further info here:
http://dev.mysql.com/doc/refman/5.0/en/explain.html
http://dev.mysql.com/doc/refman/5.0/...yze-table.html
Regards,
Angel Magaña
Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
Blog: http://cheleguanaco.blogspot.com.
Twitter: @cheleguanaco.
________
| Projects: |_____________________________________
|
| CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
| GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
| CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
| Round Robin Leads Assignment
| Phone Number Formatter
| CaseTwit (Twitter Integration)
______________________________________________
Senior Member
Re: How to find out which indexed to create in database for custom fields?
Hi,
where to enable this option (within sugar or within mysql) and where is the logfile saved then?
Andreas
A Sugar Hero | Help Forum Moderator
Re: How to find out which indexed to create in database for custom fields?
Hi AndreasOriginally Posted by andreasbalzer2
You enable it on SugarCRM.
Go to Admin -> System Settings
Take a look at the tail of the page.
Cheers
André Lopes
DevToolKit / Project of the Month - June 2009
Lampada Global Services- Open Source Solutions
Avenida Ipiranga, 318
Bloco B - CJ 1602
São Paulo, SP 01046-010
Brazil
Office: +55 11 3237-3110
Mobile: +55 11 7636-5859
e-mail: andre@lampadaglobal.com
Lampada Global delivers offshore software development and support services to customers around the world.
Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.
I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks