Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: My database is too fast

Re: My database is too fast

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Fri, 27 Jun 2003 20:52:33 +1000
Message-ID: <3efc225d$0$8262$afc38c87@news.optusnet.com.au>


"Teppicamon" <quicog_at_hotmail.com> wrote in message news:bdh5r1$srdu7$1_at_ID-162849.news.dfncis.de...

> Not at all, believe me... We wrote one application using SQLServer that made
> some quite complex queries on a materialized view resulting of joining five
> tables, one of them of about 50 million rows (guess the size of the view,
> then ;-) ). Results come to the web application users (with the network and
> asp interpretation overhead) in less than two seconds...

I'd hate to think how long it would take Oracle if Billy had counted these using a MV... ;)

> I must confess that
> I'm quite happy with Oracle also, but I really think that in general you're
> really misleaded about what SQL Server can and cannot do with similar
> hardware... or even with slightly worse hardware...
>

Narh. We just normally compare apples with apples.

>
> Nah, don't think so... He's quite happy with what he's got. If not, he would
> just buy Oracle and rename it as Oracle.NET ;-)

Yup! :D

> some backups or creating logins... They just write good SQL and voilà!! Good

If only....

> never let them try an SQL Server environment. You'd have to learn SQL Server
> administration (well, at least that's quite simple and you wouldn't have
> anything to do most of the time) or lose your job ;-)

Oh yeah, I know:

1- Shutdown
2- Backup
3- Shutdown
4- Restore
5- Startup

Bingo!, I'm a MS certified DBA!
¦D

PS: Mostly, I agree with you. ;)

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Fri Jun 27 2003 - 05:52:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US