PHP 4.0 Bug #9273: feature request: pg_cancel()
| From: | hamann dot w at t-online dot de | Date: | Thu, 15 Feb 2001 11:12:37 +0000 |
| Subject: | PHP 4.0 Bug #9273: feature request: pg_cancel() | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-46633@lists.php.net to get a copy of this message | ||
From: hamann.w@t-online.de
Operating system: Linux
PHP version: 4.0.4pl1
PHP Bug Type: PostgreSQL related
Bug description: feature request: pg_cancel()
Feature request: add pg_cancel() function
Background: although a database search script tries to
avoid "unwanted" queries, sometimes users manage to
do searches that will take considerable time, then press STOP
in their browser. With postgresql this means that the requesting
cgi process is stopped, but the actual database process
continues to run. If this happens a few times (same user requesting
slightly different data), there will be a couple of useless
processes hogging the database server.
Obvious solution (tested on tcl based cgi script) is to
use pg_cancel(), probably with a register_shutdown_function
--
Edit Bug report at: http://bugs.php.net/?id=9273&edit=1