Description of TMGDBSession Cache :
TMGDBSessionCache caches database sessions along with a TDatabase component.TMGDBSessionCache was written for 3-Tier database applications wherenormally each new thread in the middle tier has to create a new session andconnect to the database. Connecting to the database, especially to SQL servers,takes a certain amount of time. If an application constists of several remotedatamodules that each serve one client a lot of connecting/disconnectingfrom the database is necessary.MGDBSessionCache solves this problem by creating a certain amount of sessionsalong with TDatabase components attached to the sessions at program start.Threads can request a session from TMGDBSessionCache and will get the sessionname and the database name to be used in return. The returned session is alreadyconnected to the database and ready to use. When a thread has done its databasejobs and no longer needs a session, the thread releases the session soTMGDBSessionCache can reuse it.
ASP
