title: Sybase Upgrade 12.5 to 15.7 with a CIS link between two dataservers
body: <p>I am planning to upgrade a sybase dataserver from 12.5 to 15  which shares a CIS link with another 12.5 sybase dataserver.These dataservers share some tables and hence a lot of joins are across dataservers including some #temp tables.These joins are taking a lot of time to execute when there is a procedure call from say dataserver A(12.5) to dataserver B(15) where A and B have a CIS(Component Integration Services) link.
  what can be done to optimize these joins??</p>