Re: Max execution time while doing DB queries
| From: | Jeroen Geusebroek | Date: | Thu, 22 Sep 2005 19:07:19 +0000 |
| Subject: | Re: Max execution time while doing DB queries | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-223009@lists.php.net to get a copy of this message | ||
On 9/22/05, Michael Sims <michaels@crye-leike.com> 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
> another way to accomplish this with the other backends...
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 without any error message. (6 hours and more).
--
Jeroen