Re: [PERFORM] PHP Postgres query slower then PgAdmin

2013-06-25 Thread Emrah Mehmedov
On Mon, Jun 24, 2013 at 12:04 PM, Marcin Mańk wrote: > On Mon, Jun 24, 2013 at 11:55 AM, Emrah Mehmedov > wrote: > > Marcin: This heppens everytime when i try to query different keyword in > FTS > > for example: > > > > firsttime: query: "Hello & W

Re: [PERFORM] PHP Postgres query slower then PgAdmin

2013-06-24 Thread Emrah Mehmedov
y: "We & are & good" 2-3sec even if i'm going from CMD queries are faster but on first time always it's slower then rest of the times. On Sun, Jun 23, 2013 at 9:57 PM, Marcin Mańk wrote: > On Wed, Jun 5, 2013 at 1:15 PM, Emrah Mehmedov > wrote: > > [ull te

Re: [PERFORM] PHP Postgres query slower then PgAdmin

2013-06-05 Thread Emrah Mehmedov
t; > On 5 June 2013 12:02, Emrah Mehmedov wrote: > >> Can we modify php connection? >> >> >> On Wed, Jun 5, 2013 at 1:01 PM, Bob Jolliffe wrote: >> >>> Is php connecting through tcp whilst pgadmin is using unix domain >>> socket? Probably t

Re: [PERFORM] PHP Postgres query slower then PgAdmin

2013-06-05 Thread Emrah Mehmedov
Can we modify php connection? On Wed, Jun 5, 2013 at 1:01 PM, Bob Jolliffe 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:

[PERFORM] PHP Postgres query slower then PgAdmin

2013-06-05 Thread Emrah Mehmedov
MIT 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