Re: Speed of Oracle8 ?

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 Mon Jul 26 1999 - 17:10:03 CDT