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

Re: Comparative performance

From: PFC <lists(at)boutiquenumerique(dot)com>
To: Joe <svn(at)freedomcircle(dot)net>, "Gavin Sherry" <swm(at)alcove(dot)com(dot)au>
Cc: "Magnus Hagander" <mha(at)sollentuna(dot)net>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Comparative performance
Date: 2005-09-29 16:17:05
Message-ID: op.sxvguropth1vuj@localhost (view raw or flat)
Thread:
Lists: pgsql-performance
>   Total runtime: 16.000 ms

	Even though this query isn't that optimized, it's still only 16  
milliseconds.
	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

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2005-09-29 16:54:05
Subject: Re: [PERFORM] A Better External Sort?
Previous:From: PFCDate: 2005-09-29 16:12:52
Subject: Re: Comparative performance

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