Help!

[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.

[jmertic]

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.

[fer1975]

Thanks a lot. Let´s begin work!