DB and PostgreSQL on dual processor Mac OS X
| From: | Greg Lane | Date: | Mon, 02 Jun 2003 22:41:56 +0000 |
| Subject: | DB and PostgreSQL on dual processor Mac OS X | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-5741@lists.php.net to get a copy of this message | ||
Hello,
I have a data warehouse application I've built with PHP 4.3 and PostgreSQL 7.3.2 running on Mac OS X 10.2.6 on a dual 1.42 Ghz G4. I've noticed a performance issue with my application when using PEAR DB 1.4.
If I launch a complex select query (PHP page) from 3 different browser windows, I see 3 Postgres processes in Top. The first one uses >95% of one processor and the other two use 0%. When the first one finishes, the 2nd uses >95% of one processor and then when it completes, the third process finally gets a turn.
If I do the same query in 3 different windows with phpPgAdmin, all 3 Postgres processes execute immediately with each immediately getting about 65% CPU.
I've tried using both persistent and non-persistent connections.
Does anyone have an idea what DB is doing differently than phpPgAdmin that might explain this behavior?
Thanks,
Greg