Posted by Jeroen Geusebroek on 09/26/37 11:27

On 9/22/05, Michael Sims <michaels@crye-leike.com> 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 PHP calls
> dbsettime() which was unimplemented in FreeTDS in earlier versions, so you may need
> a bleeding edge version of FreeTDS to use it. If you are using FreeTDS you may want
> to ask for help on the their mailing list.
>
> If you're using Windows with the SQL Client Tools DLL then I'm not sure why the
> queries aren't timing out...

I'm using PHP 5.03 (cli) on linux with freetds-0.63. Just before your
last email i checked
the freetds.conf and i found a timeout option. But unfortunatly that
didn't help either.

It's quite easy to reproduce. Just create a idiotic long query and see
what happens ;)
I have the limit now at 10 (which i presume are seconds)

But thanks for the tip, i'll have a look at the beedling edge versions
of freetds.

Thanks!

--
Jeroen

[Back to original message]