Re: PLSQL 4X faster than internal JAVA?

Carl,

I defintely agree with Thomas

Thomas Kyte wrote:
>
>
> Since PLSQL is written for SQL -- its interaction with SQL will necessarily be
> better, faster, easier then most anything else.
>
> Even if you use N-Comped Java code in the database (compiled to object code) you
> will not see a huge speed up in this case -- Java just has to do more work to
> interact with SQL then PLSQL does.
>
> PLSQL is, and most likely will continue to be, the appropriate choice for things
> "SQL".
>

However, looking at the code you posted, perhaps more important than the nesting of the prepared statement, is the connection you are using. Although you have the java running internally, its interaction with the server is still via the thin JDBC client.

Using the internal/default driver connection should help close the gap a little...

    conn = new oracle.jdbc.driver.OracleDriver().defaultConnection ();

Ian Received on Tue Jul 17 2001 - 04:01:08 CDT