Sybrand Bakker wrote:
> >Vissu
>
> You aren't using bind varianles, are you?
> Not using bind variables is the #1 method to make Oracle unscalable.
> Also, this doesn't look much like an interactive app, so why aren't
> you using the right tool for the right job (like Sql*loader and
> similar)?
> If you have to use an interactive process, you should be performing
> BULK COLLECT and BULK INSERT, not 1 row at a time, and definitely NOT
> 1 commit PER RECORD.
>
> Your post has 'badly engineered app' inscribed all over it.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Could you explain the logic underlying your conclusions? I'm intrigued.
Received on Wed Aug 23 2006 - 06:48:23 CDT
