PHP Postgresql Problem
| From: | Samir Kuthiala | Date: | Sun, 28 Dec 2003 15:16:01 +0000 |
| Subject: | PHP Postgresql Problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32199@lists.php.net to get a copy of this message | ||
Hi
I seem to be having a problem with my PHP-Postgresql
application. The program runs fine. However if the user
closes the browser window while its loading it causes my
postgresql to increase CPU usage to about 70%-80% and
decreases the speed of the subsequent requests. Also the
CPU usage remains high even after an extended period of time.
I think that for some reason postmaster is unable to kill the
query which seems to get stuck for some reason :(
Is there any way to correct this problem. My DB is
reasonably big (~100MB). However the query I call is pretty
simple and finishes in less than a second if executed from the
command line.
thanks
Samir