From: | Bob Jolliffe <bobjolliffe(at)gmail(dot)com> |
---|---|
To: | Emrah Mehmedov <emrah(dot)mehmedov(at)x3mlabs(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: PHP Postgres query slower then PgAdmin |
Date: | 2013-06-05 11:01:39 |
Message-ID: | CACd=f9e156DZRHSpxaO=ZL9fqvHHJwBo4wdHXn7=st=4Gt+Z9g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Emrah Mehmedov | 2013-06-05 11:02:31 | Re: PHP Postgres query slower then PgAdmin |
Previous Message | Emrah Mehmedov | 2013-06-05 10:18:09 | PHP Postgres query slower then PgAdmin |