> Total runtime: 16.000 ms
Even though this query isn't that optimized, it's still only 16
Why does it take this long for PHP to get the results ?
Can you try pg_query'ing this exact same query, FROM PHP, and timing it
with getmicrotime() ?
You can even do an EXPLAIN ANALYZE from pg_query and display the results
in your webpage, to check how long the query takes on the server.
You can also try it on a Linux box.
This smells like a TCP communication problem.
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2005-09-29 16:54:05|
|Subject: Re: [PERFORM] A Better External Sort?|
|Previous:||From: PFC||Date: 2005-09-29 16:12:52|
|Subject: Re: Comparative performance|