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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: SQLJ vrs PLSQL
What I was told at the IOUG-A conference is that PL/SQL will be faster with data operations, but that SQLJ and Java will often be faster for non-data-related operations. -Original Message- From: Christopher Spence [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 22, 2001 7:50 PM To: Multiple recipients of list ORACLE-L Subject: SQLJ vrs PLSQL 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
SQLJ vrs PLSQL
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).