I have been testing a system application and have noticed that it is slow when it connects to the database overseas. This is to be expected to some extent, but there is a big difference with the domestic version, and after investigation realized that after each function the connection is closed. So, for one operation the connection is opened and closed around 30 times causing considerable lag. I asked why can't the connection be left open and closed at the end. The reply was, "It causes deadlocks".
How true is this, and if there is any advice please provide some. (System application is used by few hundred people but not constantly in use by everyone.)