Re: Unable to setup timeout for DBI execute call

Your mileage may vary, but I've never been able to get alarms to work on the Windows platform (Windows XP and server 2003 is what I've tried). I've used Perl 5.6.1 and 5.8.8 (both from Activestate) and no matter how simple the code is, the alarm never fires.

Comment on Re: Unable to setup timeout for DBI execute call

Replies are listed 'Best First'.
Re^2: Unable to setup timeout for DBI execute call by Andre_br (Pilgrim) on Mar 06, 2008 at 17:05 UTC
Hello folks, thanks for the replies I've tested the DBIx::Timeout module and it adds serious processing overhead to the code. About 50 precious milisseconds, something we can't afford to add to all our searches. In fact, on Win2K the regular techniques described here on this link didn't work: http://search.cpan.org/~timb/DBI/DBI.pm#Signal_Handling_and_Canceling_Operations But, afterall, can I expect them to work on this $dbh call on my LINUX production server? Thanks	[reply]

Replies are listed 'Best First'.

Re^2: Unable to setup timeout for DBI execute call
by Andre_br (Pilgrim) on Mar 06, 2008 at 17:05 UTC

I've tested the DBIx::Timeout module and it adds serious processing overhead to the code. About 50 precious milisseconds, something we can't afford to add to all our searches.

In fact, on Win2K the regular techniques described here on this link didn't work: http://search.cpan.org/~timb/DBI/DBI.pm#Signal_Handling_and_Canceling_Operations

But, afterall, can I expect them to work on this $dbh call on my LINUX production server?

Thanks

[reply]