Re: Speed of Oracle8 ?

As my experence:

Env:Oracle 8.04 + Sun Enterprise 4500 (4 CPU,6G RAM) Spec: 1) 1,060,000 simple queries cost 1 hour 15 minutes.

      2) 1 complex queries which joined 18 tables, 9 of them contain millions of record. there about one hunderds of colums to be selected. it cost 2 min to return from sql sentence. fetch speed is about 10000 rec / 25 sec.

Jerry Gitomer <jgitomer_at_hbsrx.com> wrote in message news:7nknqj$8vo$1_at_autumn.news.rcn.net...
> Hi,
>
> To answer your original question --
>
> "Problem:
> Project with about 700 Queries per second
> (from simple lookup to very complex queries).
> Too much for Oracle8?"
>
> Given a broad job mix Oracle 8 is just about the fastest
> RDBMS going. You can handle 700 queries per second with Oracle
> 8. (If I did my math correctly that comes out to just over
> 6,000,000 queries per day).
>
> "And what hardware is needed if it is possible with Oracle8?"
>
> Depends on the complexity of the queries, how well the
> database is tuned and how well the individual queries are tuned.
> If the 6,000,000 queries per day is real you had better expect to
> run a server with around 8GB of RAM, hire at least two heavy duty
> DBAs, and get your management to realize that they have to be
> prepared to spend, spend, spend.
>
> regards
> Jerry Gitomer
>
>
> C. Fischer wrote in message <7nima4$j13$1_at_news05.btx.dtag.de>...
> >Hi, hr784_at_cleveland.freenet.edu
> >
> >hr784_at_cleveland.freenet.edu wrote:
> >
> >>This is a question that will be very difficult to answer. As
> far as
> >>speed is concerned, I think you'll be hard pressed to find a
> faster main
> >>stream database. Informix is also fast but has many DBA
> functions built
> >>into the database engine.
> >
> >>Some question would be;
> >
> >>What kind of hardware are you running this on? If it on an IDE
> >>controller running in NT then you may have a problem as apposed
> to fiber
> >>channels to/from EMC/SUN/Boxhill disk arrays.
> >
> >At this time we are in the design-phase. The hardware must be
> >determined later, after the software is selected. That will be
> the
> >next problem (the money...).
> >
> >>A properly tuned database will have a big effect on your speed.
> I've
> >>seen many problems due to horrible PLSQL code and indexes that
> were not
> >>properly thought out. Under/Over sized SGA's, ETC...
> >
> >>Sounds as if someone in your executive staff just threw some
> figures out
> >>there and said beat it or maybe your old system could process
> >>transaction this fast!!!
> >
> >>David Knollhoff
> >
> >
> >
> >
> >
> >>In article <7mv41h$j7g$2_at_news00.btx.dtag.de>,
> >> c.fischer_at_t-online.de (C. Fischer) wrote:
> >>> Problem:
> >>> Project with about 700 Queries per second
> >>> (from simple lookup to very complex queries).
> >>> Too much for Oracle8?
> >>> Datavolume: more than 4GB.
> >>> And what hardware is needed if it is possible with Oracle8?
> >>> It would be helpful to know if 700 simple queries could be
> answered in
> >>> one second.
> >>>
> >>> bye
> >>> cf
> >>>
> >>>
> >
> >
> >>Sent via Deja.com http://www.deja.com/
> >>Share what you know. Learn what you don't.
> >
> >
>
>
Received on Sun Aug 01 1999 - 06:01:26 CDT