Posted by "Michael Sims" on 09/27/38 11:27

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...

[Back to original message]