Re: PHP Postgres query slower then PgAdmin

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