'Old problem PHP still not resolved. PDO pgsql is slower than pg functions
i fight with same issue as described here: Slow connection PHP PDO Postgres but not MySQL
here's the thing - PDO Postgresql connections seem to be really slow on my setup. I have the same database in both MySQL & Postgresql. I measured a few scenarios: PDO connection time only, PDO connection + a simple SELECT and lastly the same SELECT using pg_connect + pg_query. The pg_ methods (~25k req/s), the PDO MySQL SELECT (~12k req/s) and the PDO MySQL connection (~18k req/s) seem okay, but PDO Postgres connection (~900 req/s) and connection + SELECT (~800 req/s) seem incomparably slower. Here are my code snippets:
But cant find source of that problem it's realy php<->postgres bug? And still not resolved?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|