Re: Oracle PL/SQL Native Compilation

2008/9/19 Paul Dorsey <pdorseydulcian.com>:
> Looping through arrays will be faster than looping
through GTTs, so that will not help.

Yeahh the main idea is think "in sets" instead of
thinking "in
records". Unfortunately many programmers either simply
cannot do that
or don't know that they must do that. So most probably the
best
results you'd achieve throwing out all this stuff and
rewriting
everything from scratch (or at least programm code you'd
identify as
slowest and most often executed).
Of course it depends on many factors like:
- is it even possible
- is you/your management willing to put initially quite much
efforts
or better make small patches in longer time
- whether you have enough resources to do that
- is this soft worthy enough to do that
- etc...

Gints Plivna
http://www.gplivna.eu
-- 
For more information on this topic or to become a member,
visit our Web site at http://www.ODTUG.com  

Join ODTUG for The PL/SQL and The APEX Expert Gathering of
the Year! OPP2008 and APEXposed! 2008 will be held on
October 29-30, 2008 at the Wyndham O'Hare, Chicago. Visit
www.odtugopp.com or www.odtugapextraining.com for more
details.


-- 
Author: Gints Plivna
  INET: gints.plivnagmail.com

Fat City Hosting, San Diego, California -- http://www.fatcity.com
------------------------------------------------------------
---------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: ListGurufatcity.com (note EXACT spelling of 'ListGuru') and
in
the message BODY, include a line containing: UNSUB
ODTUG-SQLPLUS-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).