Re: Java vs PLSQL

Relatively simple answer that has been stock answer from Oracle for quite a while now:

• If more than 50% of the 'problem' is trying to do something relative to the database, use PL/.SQL
• If more than 50% of the 'problem' is relative to the web (or non-DB) use Java or JSP.

In general, PL/SQL will be faster at interacting with the database. Java does have a nice way of representing business solutions in a maintainable way. JSP are excellent at what they do - server 'pages' using Java.

So, if the complexity of you solution requires a lot of database look ups or manipulation, use PL/SQL.

Don't restrict yourself - Oracle does allow the two to be mixed through appropriate calls. (This is called partitioning the problem <g>)

HTH
/Hans

Alexander Chupin wrote:

> Hi All,
>
> There is question.
>
> Somebody told me that since Oracle 9i has been
> introduced there is a recommendation from Oracle
> do not use PLSQL for HTML pages generation anymore. Instead it we should use
> Java or JSP. I want to hear opinion of people, which
> have experience or made some performance test.
>
> WBR, Alexander Chupin
  Received on Sat Jul 21 2001 - 16:57:35 CDT