From RT_Config.pm # DBIx-SearchBuilder 1.31_1 or higher; simply set $StatementLog to be # the level that you wish SQL statements to be logged at. Set($StatementLog,undef);
I am not sure what the different levels but : Set($StatementLog,1); will be a good start. Remember to restart your web server. Regards; Roy Varun Vyas wrote: > Hello All > > Can anyone can tell me how i can log my queries that hits my database in > RT.log. I am using oracle 9i and RT 3.6.3 we have a performance issue as > our RT is very slow and takes 15-20 seconds for database operations. So > i want to log my queries so that i can then analyze them for performance > optimisation. And also i m getting internal server error frequently can > any one tell me how can i correct it > > Any help in highly appreciated > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com