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.
On Wed, Jun 5, 2013 at 1:11 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
Most probably. If your existing connection string specifies something like "host=localhost port=5432 ..." just remove the host and port parameters and php will by default try to connect with unix domain socket.On 5 June 2013 12:02, Emrah Mehmedov <emrah.mehmedov@xxxxxxxxxxx> wrote:
Can we modify php connection?
On Wed, Jun 5, 2013 at 1:01 PM, Bob Jolliffe <bobjolliffe@xxxxxxxxx> 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.mehmedov@xxxxxxxxxxx> 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 MehmedovSoftware Developer @ X3M Labs
http://www.extreme-labs.com--Best regards, Emrah MehmedovSoftware Developer @ X3M Labs
http://www.extreme-labs.com
Best regards, Emrah Mehmedov
Software Developer @ X3M Labs
http://www.extreme-labs.com
http://www.extreme-labs.com
