Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Is Xeon really fast?
In article <oD_a2.3505$KG4.2233010_at_news.teleport.com>,
barbken_at_teleport.com (Barbara Kennedy) wrote:
> Avoid host variables in where clauses? I think you mean use host
> variables
> in where clauses. All actual benchmarking I have ever done indicates
> that
> using host variables gives a performance increase.(CPU decrease)
> Jim
> Mike Gribbins wrote in message <74h1c8$576_at_agbinet.air.ups.com>...
> >>My suspicion is that it would be a more effective approach to spend
> >>$15,000 on having:
> >>a) A *pile* of RAM, and
> >>b) Several SCSI controllers and a *bunch* of SCSI disks, arranging
> >>things so that the heavily indices and tables are spread across
> >>separate disks,
> >
> >Yes, and on a second note about the indices, you want to make sure your
> code
> >uses efficient stage 1 queries when possible. Always match on data
> type
> and
> >length, and avoid host variables in where clauses.
> >
> >
> >
> >
>
>
I always find host variables give better results too .... provided that
you don't re-parse the cursor
Dave Lane (dlane_at_pt.lu) Received on Tue Dec 08 1998 - 15:51:59 CST