Re: PHP Postgres query slower then PgAdmin - Mailing list pgsql-performance

From Marcin Mańk
Subject Re: PHP Postgres query slower then PgAdmin
Date
Msg-id CAK61fk7tVCsN0Y4Fr+y+=g+M0izbJnZwTK_ejTWyyd5D+V+PyQ@mail.gmail.com
Whole thread Raw
In response to Re: PHP Postgres query slower then PgAdmin  (Emrah Mehmedov <emrah.mehmedov@x3mlabs.com>)
Responses Re: PHP Postgres query slower then PgAdmin  (Emrah Mehmedov <emrah.mehmedov@x3mlabs.com>)
List pgsql-performance
On Wed, Jun 5, 2013 at 1:15 PM, Emrah Mehmedov
<emrah.mehmedov@x3mlabs.com> wrote:
> [ull text search]
> I notice something in CMD, first time query is executing same time like from
> php all the time, but on the rest of the time that i will execute the query
> is faster from cmd, php is keeping the same execution time.
> i also change the connection string (i remove host and port) and nothing
> changed.

The first query using a text search config loads the dictionaries, so
it is slower, and that's why the following queries are faster. I think
your PHP persistent connections don't work too well.

Regards
Marcin Mańk


pgsql-performance by date:

Previous
From: Tom Kincaid
Date:
Subject: Re: PHP Postgres query slower then PgAdmin
Next
From: Emrah Mehmedov
Date:
Subject: Re: PHP Postgres query slower then PgAdmin