Thread: Load of 4 Million Queries Read and or Write Per Second

Load of 4 Million Queries Read and or Write Per Second

From
"Timothy J Hitchens"
Date:
That is 4 Million Queries per Second which is 14 Billion 400 Million per hour.
 
This may sound a little big but this is what we will be launching on the 1st December 2000 using postgresql and php.
 
It is a new generation client/server environment that allows communication/transactions and information storage for b2b, b2c and p2p.
 
Does anyone have a qlue what will happen and what should I order now to replace the box we have and what size
space should I clear in the office/warehouse for expansion.
 
I am serious and would like some feedback and input.
 
 
 
Hitcho has Spoken.
Timothy Hitchens (Hitcho)
tim@hitcho.com.au
 

RE: Load of 4 Million Queries Read and or Write Per Second

From
Paul McGarry
Date:
> That is 4 Million Queries per Second which is 14 Billion 400
> Million per
> hour.
>
> This may sound a little big but this is what we will be

I think that may just be the biggest understatement I have
ever read. I'll just include a little quote from a press
release by a company about setting up WWW based voting in
America. Perhaps it will lend some perspective to the task
you are describing.

====
META Group estimates that a national Web-based system would require 150
individual Web sites using a distributed computing method to handle the
Web traffic generated by more than 204 million eligible US voters.

Voters would be able to cast their ballots online -- at home, in the
office, or at community polling locations. Voters would download
approximately 10 pages of data as they completed ballots within a
15-hour voting period. META Group estimates that 13,628,134 voters would
cast their ballots each hour during election day, visiting 136,281,336
Internet pages per hour. To handle this load, the 150 sites would need
to be outfitted with 300 dual-CPU Web servers, 450 four-CPU application
servers, and 450 four-CPU database servers.
====
The full release is here:
http://domino.metagroup.com/newweb.nsf/oPressRelease/F956632E704768E4852
5699F0056EF36?OpenDocument

Perhaps another piece of perspective is that you seem to be wanting to
do a query for every person on earth every half hour.
http://www.census.gov/cgi-bin/ipc/popclockw

Or one query every 1.5 minutes for every person with a connection to the
internet.
http://www.nua.ie/surveys/how_many_online/index.html

Crumbs......

--
Paul McGarry            mailto:paulm@opentec.com.au
Systems Integrator      http://www.opentec.com.au
Opentec Pty Ltd         http://www.iebusiness.com.au
6 Lyon Park Road        Phone: (02) 9878 1744
North Ryde NSW 2113     Fax:   (02) 9878 1755