Re: [Mifos-users] Tips for troubleshooting Report Performance?

2009-09-02 Thread Parthasarathy.Thanda
Yes, if mysql service is configured appropriately, it will log the queries that take > specific seconds (long_query_time parameter) to execute in a separate file. The queries in this file can be analysed and tuned to improve performance. Additionally, on a non-live server we can even configure the

[Mifos-users] Tips for troubleshooting Report Performance?

2009-09-02 Thread Ryan Whitney
Hello all, Working on some reports and running into performance issues. What tips do people have for troubleshooting? I remember reading some threads about turning on ³slow queries log² on the dev list? Be good to also add this to mifos.org Thanks, Ryan -- Ryan Whitney Mifos Technical Progr