From: | Emrah Mehmedov <emrah(dot)mehmedov(at)x3mlabs(dot)com> |
---|---|
To: | Bob Jolliffe <bobjolliffe(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: PHP Postgres query slower then PgAdmin |
Date: | 2013-06-05 11:02:31 |
Message-ID: | CAGRV00KpfX5-4gZiV2tcY+StYYTG04f0W3bV2XsFXUFtzVF3bw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Can we modify php connection?
On Wed, Jun 5, 2013 at 1:01 PM, Bob Jolliffe <bobjolliffe(at)gmail(dot)com> wrote:
> 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
>>
>
>
--
Best regards, Emrah Mehmedov
Software Developer @ X3M Labs
http://www.extreme-labs.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Jolliffe | 2013-06-05 11:11:49 | Re: PHP Postgres query slower then PgAdmin |
Previous Message | Bob Jolliffe | 2013-06-05 11:01:39 | Re: PHP Postgres query slower then PgAdmin |