Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Does the size of psp scripts impact the performance?

Does the size of psp scripts impact the performance?

From: Gerhard Möller <moeller_at_offis.de>
Date: Fri, 14 Nov 2003 10:56:43 +0100
Message-ID: <bp28t7$sll@news.Informatik.Uni-Oldenburg.DE>


Hi,

we have to decide whether to put our code into one larger psp (with includes, of course), seperated with IF, or to split up the code into several smaller pieces. My question now is:

Does the size of a psp have an impact to the performance (not all the code gets executed, think of it as a big IF-cascade of smaller programms)? Or would it be better to have smaller PSP stand-alone programs? (Obviously this includes the question if the PSP programs are cached in the main memory or if they get flushed out of the memory after execution...)

-- 
Gerhard Moeller, Carl-von-Ossietzky Universitaet Oldenburg
mailto:moeller_at_offis.de  -  Tel.: +49-441-9722 122
Received on Fri Nov 14 2003 - 03:56:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US