Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is Oracle slower than sql server
Faisal:
1) If the procs are not related there is no reason to put them together
in a package and it can affect performance because when you call a proc
into a package the hole package will be loaded in RAM.
2) You can consider using external tables instead of sqlldr.
See:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:6611962171229
for details.
Best regards.
Received on Thu Jul 27 2006 - 02:22:11 CDT