RE: Max execution time while doing DB queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux