OraFAQ Forum: SQL & PL/SQL » SQL & PL/SQL compared against JDBC / ODBC

Home » SQL & PL/SQL » SQL & PL/SQL » SQL & PL/SQL compared against JDBC / ODBC (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL & PL/SQL compared against JDBC / ODBC [message #320989]

Sat, 17 May 2008 07:28

1Luke1
Messages: 3
Registered: May 2008

Junior Member

Hey all, new to the forum and the majority of the oracle world. I have been posed a question, and was really just looking for any hints / help into areas that I should look into.

The question is 'Investigate the use of JDBC/ODBC and evaluate it against other forms of database access (embedded SQL and PL/SQL)'

I was wondering if there was any heuristics or algorithms that I could test, or if it would be testing things such as length of code? And running queries to test things like the speed at which data was processed or returned from tables?

Any help, bulletpoints, websites etc would be appreciated, thanks.

Luke

[Updated on: Sat, 17 May 2008 07:51]

Report message to a moderator

Re: SQL & PL/SQL compared against JDBC / ODBC [message #320991 is a reply to message #320989]

Sat, 17 May 2008 08:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>The question is 'Investigate the use of JDBC/ODBC and evaluate it against other forms of database access (embedded SQL and PL/SQL)'

As a general rule embedded SQL will "always" be fastest;
next comes PL/SQL;
& lastly JDBC/OBDC.

Keep in mind that eventually it is SQL that is being processed by the RDBMS engine; because that is the only query language the database understands.

Everything else is a "higher level" mechanism for invoking SQL.

Which is better or more efficient is dependent upon many external factors and depends upon which metrics are deemed most important.

Report message to a moderator

Re: SQL & PL/SQL compared against JDBC / ODBC [message #320995 is a reply to message #320991]

Sat, 17 May 2008 09:05

1Luke1
Messages: 3
Registered: May 2008

Junior Member

Thanks for the input, will reply to your thread as you put some time into mine.

> With the ''JDBC / ODBC being 'slowest' database access.''

Is this because it's like (metaphorically speaking) an open platform, for lots of different access paths (C, vb, java etc) to connect through, so it has to check more things, or is it because the coding with the JDBC itself is more detailed and requires to execute more commands?

I understand (or think i understand) that embedded SQL will be the quickest because as you said:
'that is the only query language the database understands.'
(cant find the 'quote' button sorry Sad

) And the DBMS has to do less 'breaking down'.

Would there be ways to show / prove this within oracle?
(Regarding coding I could produce, that could be used against the 3 different types to provide some results that are easily comparable?)

Thanks again, Luke

P.s. Hope my etiquette is ok, and I am not being too vague, as I am not 100% myself in the area in question)

Report message to a moderator

Re: SQL & PL/SQL compared against JDBC / ODBC [message #320997 is a reply to message #320995]

Sat, 17 May 2008 09:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

1Luke1 wrote on Sat, 17 May 2008 07:05

> With the ''JDBC / ODBC being 'slowest' database access.''

Is this because it's like (metaphorically speaking) an open platform, for lots of different access paths (C, vb, java etc) to connect through, so it has to check more things, or is it because the coding with the JDBC itself is more detailed and requires to execute more commands?

Any access by a system external to the database server will inherently be slower than access from on or inside the DB server.
Any "overhead" or setup done on external system will not directly impact performance of the database server but could impact application response time as perceived by end user.

Report message to a moderator

Re: SQL & PL/SQL compared against JDBC / ODBC [message #320999 is a reply to message #320997]

Sat, 17 May 2008 10:09

1Luke1
Messages: 3
Registered: May 2008

Junior Member

Yeah, kinda logical but thanks, Any other input is appreciated Smile

Luke

Report message to a moderator

Previous Topic:	Help Required
Next Topic:	Question in Pl/Sql Joins

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 15:29:07 CST 2024