Well 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.
Well 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.
You might have 8G or RAM but how much is being allocated to Oracle ?
Please specify in either terms of SGA/PGA and automatic memory
allocation or as dedicated SGA/blockbuffer pool allocations
Further is it Oracle that is slow or is it Apache that is being slow?
Which things are slow? (Searching on ticket CONTENT is without proper
context indexing reeeaaaal slow.), not to mention that standard
SearchBuilder pre and post pends % to queries, effectively disabling the
use of indices :-((
Regards,
Joop
(PS:
Contact me off list if you need specific help
)