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.
se
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
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 die
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 t
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
