Re: the need for speed

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. Received on Wed Nov 22 2000 - 10:52:25 CST