Re: PHP Postgres query slower then PgAdmin

Is php connecting through tcp whilst pgadmin is using unix domain socket?
Probably the query time is the same, but returning the result over tcp
will be slower.

On 5 June 2013 11:18, Emrah Mehmedov <emrah(dot)mehmedov(at)x3mlabs(dot)com> wrote:

> Hello,
>
> I'm using php5.4.12 with extension=php_pgsql.dll enabled but the query
> that i'm trying to execute is faster on PgAdmin app.
>
> SELECT title, ts_rank_cd(vector, query) AS rank FROM links,
> to_tsquery('english', 'risk') query WHERE query @@ vector ORDER BY rank
> DESC;
>
> I'm not sure, what can i do to increase the speed of execution from php:
>
> $start_time = microtime(true);
> $query = "SELECT title, url, ts_rank_cd(vector, query) AS rank FROM links,
> to_tsquery('english', 'risk') query WHERE query @@ vector ORDER BY rank
> DESC LIMIT 10;";
> $result = pg_query($connection, $query);
> $end_time = microtime(true);
>
> persistant connections are enabled in php.ini but i calculate only
> execution time from start to end.
>
> Thanks, Emrah.
>
> --
> Best regards, Emrah Mehmedov
> Software Developer @ X3M Labs
> http://www.extreme-labs.com
>