Hi Raed El-Hames I am so sorry if i have bothered you but as i am new to this mail list i am also not aware that i need to reply to all users in list and not individual.
Raed El-Hames wrote: > 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 >>>>>> >>>>>> >>>>> >>>> >>> >> >> >> > > -- Thanks & Regards Varun Vyas Software Engineer - Automation Elitecore Technologies _______________________________________________ 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
