SQR vs. PL/SQL on Performance

[Ed Crotty <Ed_Crotty@COMPUSERVE.COM>]

For hard core bulk data manipulation ( i.e. for rollback avoidance) , that
doesn't require a lot of conditional logic, etc,  PL/SQL will be faster
because the data doesn't have to move from database memory to program
memory and back again.   SQR will be the choice for anything involving
printed output ( PL/SQL file handling sucks ) as well as anything with
difficult logic SQR will be WAY easier to write and read later.   The good
news is that SQR can call stored procedures whenever you think that PL/SQL
is going to be faster, so you can have the best of both worlds!

Ed Crotty
BALR Corporation
Oak Brook IL
(630)575-8200x184