Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Does the size of psp scripts impact the performance?
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 122Received on Fri Nov 14 2003 - 03:56:43 CST