Re: the need for speed

But a Ferrari is built for one thing...driving fast, very fast. Oracle is built to handle multiple configurations very well. It just takes some tuning to get it to handle your specific task. After all, if you bought a Ferrari and later decided to go four-wheeling, you'd have to change the tires wouldn't you? :)
Brian

tim_bedford_at_my-deja.com wrote:
>
> Yes but a Ferrari works when you get it, and you have to damage it for
> it to stop working. Oracle seems like you're given a milling machine and
> a welder and told that you can build a Ferrari with it.
> Just kidding-ish.
> thanks Brian I'll dig deeper.
>
> Tim
>
> In article <3A1BD621.73293BAC_at_edcmail.cr.usgs.gov>,
> Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> > Lots of factors can cause the performance that you are seeing. Even a
> > Ferrari can perform poorly at times. Throw some bicycle tires on it
 and
> > pour sugar in the gas tank. Now even a little Honda motor scooter can
> > beat it. But take care of the Ferrari and the motor scooter will never
> > even come close.
> >
> > For starters, searching for half of a 100,000 row table is quickest by
> > doing a full table scan. Are you using an index in your search? If so,
> > that can slow it down. You'll have to use EXPLAIN PLAN to determine if
> > you are using an index.
> >
> > After that, look at things like you BUFFER CACHE. How big (or small)
 is
> > it? How about other tuning aspects? Refer to the Oracle Tuning Guide.
> >
> > HTH,
> > Brian
> >
> > tshb_at_techprt.co.uk wrote:
> > >
> > > Hi,
> > > I'm very new to Oracle and databases generally, so this might be a
> > > stupid question. I'm searching for fifty thousand values (stored as
 the
> > > primary key in a table) in a table of one hundred thousand (again,
 the
> > > primary key). The SQL is SELECT n.ID, c.ID FROM temp n,main c WHERE
 c.ID
> > > = n.ID ORDER BY n.ID.
> > > No great shakes, I'm just wondering why it takes about 4 seconds to
 do
> > > it (from SQL Plus). Shouldn't it be quicker? Admittedly its a lot
> > > quicker than Access but how come search engines can find fifty
 trillion
> > > pages in 0.4 nano-seconds?
> > > I'm using Oracle 8 Personal Edition, would using another version
 speed
> > > it up?
> > > thanks,
> > >
> > > Tim
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> > --
> > ========================================
> > Brian Peasland
> > Raytheons Systems at
> > USGS EROS Data Center
> > These opinions are my own and do not
> > necessarily reflect the opinions of my
> > company!
> > ========================================
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================