TMGDBSession Cache 1.0

In category

DB-Aware Components > DB Access > Other

Description

TMGDBSessionCache caches database sessions along with a TDatabase component. TMGDBSessionCache was written for 3-Tier database applications where normally each new thread in the middle tier has to create a new session and connect to the database. Connecting to the database, especially to SQL servers, takes a certain amount of time. If an application constists of several remote datamodules that each serve one client a lot of connecting / disconnecting from the database is necessary.

MGDBSessionCache solves this problem by creating a certain amount of sessions along with TDatabase components attached to the sessions at program start. Threads can request a session from TMGDBSessionCache and will get the session name and the database name to be used in return. The returned session is already connected to the database and ready to use. When a thread has done its database jobs and no longer needs a session, the thread releases the session so TMGDBSessionCache can reuse it.

Informations

• Status: Fully functional
• Source: FW
• Size: 8 373kB

Platforms:

• C++ Builder 3
• C++ Builder 4
• C++ Builder 5
• Delphi 2
• Delphi 3
• Delphi 4
• Delphi 5

Downloads

• C++ Builder 3 , C++ Builder 4 , C++ Builder 5 , Delphi 2 , Delphi 3 , Delphi 4 , Delphi 5