[rt-users] RT Query Logging

[Raed El-Hames]

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