Re: PostgreSQL client api

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Antimon <antimon(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL client api
Date: 2006-03-29 01:06:13
Message-ID: 20060329010613.GD561@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-general by date

  From Date Subject
Next Message paul rivers 2006-03-29 01:11:59 Re: PostgreSQL client api
Previous Message Antimon 2006-03-29 01:01:45 PostgreSQL client api