* Alfred Perlstein <bright@wintelcom.net> [001123 14:33] wrote:
> * Timothy J Hitchens <tim@hitcho.com.au> [001123 13:35] wrote:
> >
> > 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.
>
> What platform is this going to be on? You will not be able to do
> 4 million queries per second with Postgresql on a PC platform.
You do realize that even a 800Mhz Pentium that the math makes
this practically impossible:
800Mhz == 8,000,000 cycles per second
divided by 4,000,000 queries per second
= 2 cycles per query
Those two cycles are spent even before the server gets to
parse the query.
What are you trying to do here?
--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."