Fw: SQR to PL/SQL2

["Ray Ontko" <rayo@ontko.com>]

Does anyone want to take this up?
------------------------------
From: Christopher Larson <Christopher.D.Larson@CDC.COM> 
Thu, 20 Apr 1995 08:52:17 -0500
To: Multiple recipients of list ORACLE-L <ORACLE-L@CCVM.SUNYSB.EDU>
Subject: SQR to PL/SQL2

                      Subject:                              Time:  8:34 AM
  OFFICE MEMO         SQR to PL/SQL2                        Date:  4/20/95

Hello all you "Oracle Heads"!!
I have a slight problem I am hoping you can help me with.
I have recently converted from V6 to V7.1.3.2 on a MIPS ABI system.  Along with
this we have decided to convert our SQR reports to PL/SQL2. (an attempt to save
a little cash!)
All these new PL/SQL reports are now running an average of 25% longer than the
SQR using the exact same SQL code.
It appears once the first page is displayed it runs just fine through the rest.
Does the "PL/SQL startup process (so to speak)" have that much overhead??
Has anyone else noticed this?

Any suggestions on speeding this up would be of great help!!!

Thanks!

Chris Larson
Oracle DBA, Contol Data Systems
Christopher.D.Larson@cdc.com
-----------------------------------------------------------------------
Ray Ontko       rayo@ontko.com  "Ask me about Database Illustrator(tm)"
Ray Ontko & Co  info@ontko.com   ftp.ontko.com:/users/ontko (anon ftp)