http://www.perlmonks.org?node_id=1039612


in reply to DBD::Sybase query execute hangs randomly for Sybase IQ 15.4

Ditto.   Since the code “runs fine,” there is really no reason to presume that the root cause of the problem is within this code.   Next time the program freezes, list the active connections and find yours; then, list the units-of-work for that connection.   This, and really only this, will tell you what is actually going on.   It’s going to be resource-contention, or a lock that is bigger than it needs to be, or simply a throttling parameter of some kind, all of which are not “bugs in your code.”