How good is the RT3 support for an Oracle DB?

Todd_Chapman · March 25, 2004, 10:14pm

I have been happily developing a customized RT3 against
a MySQL database for our company. For production I may
be forced to use Oracle. How good is the RT3 support
for Oracle? Is there much of a performance difference?
Any gottchas I should watch out for?

Thanks!

-Todd

Paulo_Matos · March 26, 2004, 11:02am

I have been happily developing a customized RT3 against
a MySQL database for our company. For production I may
be forced to use Oracle. How good is the RT3 support
for Oracle? Is there much of a performance difference?
Any gottchas I should watch out for?

Most of this issues are RT independent, for problems, improvemnents,
performance or other you should start looking at:

http://search.cpan.org/dist/DBD-Oracle/Oracle.pm

You might get erroneus performance reports depending on Oracle setup.
Performance tunning on Oracle is much more sofisticated and tricky than
MySQL. Usually Oracle defaults are good but with tunning you can almost
always get more from it.

Hope this helps,

Paulo Matos