Hi,
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.
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
On 9/22/05, Michael Sims [EMAIL PROTECTED] wrote:
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
Jeroen Geusebroek wrote:
For this application i'm using a MSSQL database. There is an ini
setting (mssql.timeout) which should do what i want but afiak doesn't
work. It defaults to 60 which i assume are seconds.
My app has had times that it was waiting way longer then that before
it died
On 9/22/05, Michael Sims [EMAIL PROTECTED] wrote:
What platform/driver? If Linux, are you using FreeTDS and if so what
version? It
looks like the timeout is handled in the TDS library, not at the PHP level.
I did
some poking through the FreeTDS mailing list archives and it seems that
On 9/22/05, Michael Sims [EMAIL PROTECTED] wrote:
http://lists.ibiblio.org/pipermail/freetds/2005q3/018774.html
According to that it's in 0.64
I'll have it a go tomorrow. Looks hopeful!
Will let you know.
--
Jeroen
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
6 matches
Mail list logo