Varun; There is no straight forward answer to this , you possibly should start by stating your RT version, DB type(oracle,mysql ??) and version , apache, mod_perl or fastcgi etc .. Also search the wiki and mailing list there are lots of posts and a good article in the wiki covering this.(sorry don't remember the url).
Good luck; Roy Varun Vyas wrote: > And i want to know one more thing as my RT is slow right now .What steps > should i take to increase its performance on application side or on > database side. We have remote database on our RT and it has 2 gigs RAM. > > Raed El-Hames wrote: > >> 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