RE: [PHP] Max execution time while doing DB queries
| From: | Michael Sims | Date: | Thu, 22 Sep 2005 18:20:38 +0000 |
| Subject: | RE: [PHP] Max execution time while doing DB queries | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-223002@lists.php.net to get a copy of this message | ||
Jeroen Geusebroek wrote:
> I was wondering how i can limit a script from waiting too long for
> a database query to return.
>
> The problem is that it will wait an infinite time while performing a
> query on a database when there is for example a lock on a table. I
> want it to exit/fail when a set amount of time has passed.
What RDBMS are you using? If you are using Postgres you can use pg_send_query()
which is non-blocking. I don't think the other database backends/php drivers
support such functionality, but I could be wrong... Maybe someone else knows of
another way to accomplish this with the other backends...