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 -> Re: high through put system

Re: high through put system

From: gazzag <gareth_at_jamms.org>
Date: 23 Aug 2006 04:48:23 -0700
Message-ID: <1156333703.590150.235130@75g2000cwc.googlegroups.com>


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

Original text of this message

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