Skip site navigation (1) Skip section navigation (2)

PostgreSQL client api

From: "Antimon" <antimon(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL client api
Date: 2006-03-29 01:01:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I was testing MySQL and PgSQL performances on my home box (amd athlon
64 3000, 1gig ddr ram, sata I hdd, win xp (x86)), select and insert
times seeemed identical with innoDB.

But when i try to query both using php, there's a huge difference even
for a funny query like "select 1"

Here's the code:

$mtime = microtime(true);

$pdo = new PDO('pgsql:host=localhost;dbname=test', "testacc", "pw");
for ($i = 0; $i < 10000; $i++)
	$result = $pdo->query("Select "+$i);

echo microtime(true) - $mtime;
echo "<br>";

$mtime = microtime(true);

$pdo = new PDO('mysql:host=localhost;dbname=test', "testacc", "pw");
for ($i = 0; $i < 10000; $i++)
	$result = $pdo->query("Select "+$i);

echo microtime(true) - $mtime;
echo "<br>";

output is:

Nearly 3 times slower even w/o any table queries. But i could not
reproduce this by writing stored procs on both which selects 0-10000 in
a loop to a variable. results were almost same.
(I tried pg_ and mysqli_ functions too, results were not too different)

Is it mysql client libraries performs better? Or postgre stored procs
are 3x faster? I cannot understand, since there is not even an io
operation or any query planning stuff, what is the cause of this?



pgsql-general by date

Next:From: Jim C. NasbyDate: 2006-03-29 01:06:13
Subject: Re: PostgreSQL client api
Previous:From: Scott MarloweDate: 2006-03-28 22:33:00
Subject: Re: best practice in upgrading db structure

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group