Varun; You should make it a habit to reply to the list and not individuals , I have never deployed RT with Oracle so can't help you -- few in the may though
ps: A pointer so you know what RT is capable of , our RT db is > 50G in size, the attachments table alone is > 26G, our db server is quad dual core with 16 G Ram (4x4) and the web server is standard 3.6G cpu with 3G Ram, average per day tickets is ~ 1000 with 200 internal users and 10000+ external customer users. Regards; Roy Varun Vyas wrote: > We have deployed RT 3.6.3 on oracle 9i database as an backend > in a medium sized firm and we have lots of tickets processed > everyday more than 100. My problem is that the application is very > irresponsive and very slow. We have already 8 gigs of RAM on our > webserver with Apache 2.0 and fastCGI implemented. Also we have > performed indexing on our oracle database with fastcgi implemented. But > nothing seems to be going in our way. So please anyone can suggest wat will > be the problem. I m looking for concerete answer to my problem. On which side > i need to tune on application side or on database side and if on both side > what step i need to take to make my application lightning fast.With > acceptable level of performance. > > And i have looked for all this things in google and have searched a lot from > past two months but has found nothing. > > > > Raed El-Hames wrote: > >> 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: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
