Well its a old application using Sybase as database e have more then 113 million records to process so time taken by it is normal.
I am getting your point but application was working fine from last 10 years before this new firewall was installed.
What we tried so far..
1.Ran a new
thread calling the query on same connection but this query went into the sybase queue and is getting processed after the first query complete .So it was a fail attempt.What ever we are calling on sybase is being sent to a queue.so e are not able to keep connection busy to be up for long.
2.changing firewall setting is not a option with us.
3.We tried to make a socket connection on the same port so tht it is busy .and ran setKeepalive function on it.