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.mehme...@x3mlabs.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
>
