Re: Help!

Originally Posted by
fer1975
Hello All,
i have begin working in an enterprise that have a SUGAR CRM with MYSQL Database. I will have to optimize the querys and the reports but i have speak with the developers and they said to me than SUGAR generates the querys automatically.
I have some questions:
1 - ŋItīs posible to modify the querys generates by SUGAR or execute our own querys?. Does anybody recommend this or itīs better to keep the querys and try to create some index, etc without touching it?
2 - ŋItīs there any module that allows us generate reports using or own sql querys?
Thankīs to all and sorry about my english.
I think your best bet is to turn slow query logging on and see what the slow queries being run are. Then, go back to the MySQL server and add the correct indexes needed to speed up those slow queries.
John Mertic
Sugar Community Manager
Bookmarks