By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,850 Members | 1,771 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,850 IT Pros & Developers. It's quick & easy.

Comparison of Performance of SQL and external Procedures

P: n/a
vj
Please advice me with a few comparison facts of SQL Procedures and
External Procedures ( c or java ) .

-Vj

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
vj wrote:
Please advice me with a few comparison facts of SQL Procedures and
External Procedures ( c or java ) .

-Vj

< := "faster than":
Unfenced C < SQL PL < fenced C < Java (always fenced)

This is a thumb rule. The heavier the SQL teh less it matters.
Nothing, obviously beats C in pure procedural logic or math (short of
Assembly).
In general customers find SQL Procedures a lot easier to digest than C
Procedures ("native" interfaces).
For some of the lower level interfaces (like LOAD or file I/O) there are
presently no SQL hooks, so you need to use C Procedures for those, which
in turn can then be called by SQL Procedures.
SQL PRocedures and Java are portable.
C Procedures are portable if you stick with ANSI C.

Is this what you were looking for?

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
vj
Yes ... thanks a lot for the wonderfull explanation.
--
I was planning to chose Java Procedures.. exception handling I felt to
be good over there.
--
As u said .. C Procedures wud handle the low level interfaces.
--
THanks for the input.. let me decide depending on the requirements

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.