Re: PostgreSQL client api - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: PostgreSQL client api
Date
Msg-id 20060329010613.GD561@pervasive.com
Whole thread Raw
In response to PostgreSQL client api  ("Antimon" <antimon@gmail.com>)
List pgsql-general
On Tue, Mar 28, 2006 at 05:01:45PM -0800, Antimon wrote:
> $pdo = new PDO('pgsql:host=localhost;dbname=test', "testacc", "pw");
> for ($i = 0; $i < 10000; $i++)
> {
>     $result = $pdo->query("Select "+$i);
> }
> output is:
> 2.7696590423584

Ok, so that tells me that on this plain-vanilla hardware, you can
'only' do 3600 queries per second from PHP.

Who cares?

If you're actually trying to run that kind of volume on that kind of
hardware, you need to reconsider what you're doing.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: "Antimon"
Date:
Subject: PostgreSQL client api
Next
From: "paul rivers"
Date:
Subject: Re: PostgreSQL client api