Home » SQL & PL/SQL » SQL & PL/SQL » SQL & PL/SQL compared against JDBC / ODBC (Oracle 10g)
SQL & PL/SQL compared against JDBC / ODBC [message #320989] Sat, 17 May 2008 07:28 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: SQL & PL/SQL compared against JDBC / ODBC [message #320995 is a reply to message #320991] Sat, 17 May 2008 09:05 Go to previous messageGo to next message
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)
Re: SQL & PL/SQL compared against JDBC / ODBC [message #320997 is a reply to message #320995] Sat, 17 May 2008 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: SQL & PL/SQL compared against JDBC / ODBC [message #320999 is a reply to message #320997] Sat, 17 May 2008 10:09 Go to previous message
1Luke1
Messages: 3
Registered: May 2008
Junior Member
Yeah, kinda logical but thanks, Any other input is appreciated Smile

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


Current Time: Sat Dec 03 08:24:53 CST 2016

Total time taken to generate the page: 0.23172 seconds