Because a cached connection never disconnects from the remote server, any state information held in that server regarding the user’s session is maintained between the time the user disconnects from OpenSwitch and reconnects to the cached connection.
This mean that temporary tables and “SET” options (except for “set database,” which is cleared) are maintained even after a user disconnects. Evaluate carefully how you use connection caching.
