| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQLJ vrs PLSQL
Hello, Christopher,
It is not faster. SQLJ is jdbc by nature, simply SQLJ precompiler
facilitates some tasks like variable binding. After compilation this is
normal java code. PL/SQL always outperformes Aurora JVM making SQL
operations.
HTH
Vadim Gorbounov
Oracle DBA
-----Original Message-----
Sent: Sunday, July 22, 2001 8:50 PM
To: Multiple recipients of list ORACLE-L
I have a friend who states SQLJ is faster PLSQL, so I started reading up on SQLJ, which I have always avoided as it didn't seem to impressive and I try to avoid any sql in java files. In reading, I noticed it calls a "SQLJ" runtime which is java. I can't believe this would outperform native PLSQL which only has to do a single context switch to make a SQL call.
Anyone have any experience either way? Even Oracle claims PLSQL is faster:
"PL/SQL is a better solution for SQL-intensive applications. PL/SQL is optimized for SQL, and so SQL operations are faster in PL/SQL than in Java. Also, PL/SQL uses SQL datatypes directly, while Java applications must convert between SQL datatypes and Java types."
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: cspence_at_FuelSpot.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jul 23 2001 - 13:31:28 CDT
 |
 |