Re: Top Databases Used

Obnoxio The Clown wrote:
>
> From: Frank1 <karthiksNOkaSPAM_at_citiesnetwork.com.invalid>
>
> > Try tpc.org for hard numbers on different database performance.
>
> Well, and I'm not standing up for the idiots here, but Informix haven't done
> a TPC-C benchmark for ages. So it's not really a valid basis for comparison.
>
> >and if u want to know what DBs some of the big sites use go to
> >PC Magazine's web site and look for a Oct 19th 1999 article
> >titled "What makes the Big sites run"
>
> What, on PCs? :0)
>
> Anyway, what makes big sites run is huge chunks of shiny tin. :-)
>
> I'm at "a leading UK e-commerce site" and we serve something like 200
> pages/second in peak time. Before we went to pooled connections, we had over
> 2000 active connections reported by onstat -u when we got busy. And I heard
> that the *home* page has something like 60 stored procedure calls in it. Go
> figure. Anyway, I'm quite happy with _database_ performance. The stuff on
> the front is a whole 'nother thing...

To generate the full home page there are over 130 SQL statements run.

-- 
Paul Watson             #          
WF Software Ltd         # You are only young once
Tel: +44 1436 674729    # but you can be immature
Fax: +44 1436 678693    # for ever
www.wfsoftware.com      #