• Algorithms
• Application
• Components
• Database
• Distributed aplication
• DLL
• Errors
• Events
• Hardware
• IDE
• Install Shield
• Internet
• Multimedia
• Object Pascal
• Operational system
• Others
• Security
• Third party
• Win API

Minimizing Connections

Question:

How can I demonstrate the use of fewer database connections than clients using our three-tier application? For example, I would like to show 10 clients using no more than 5 database connections.

Answer:

Actually, you can have all 10 clients use 1 database connection. Put a TDatabase on the RemoteDataModule and set HandleShared to True. The database will login once no matter how many clients are connected to your application.

Note: Be sure to check your licensing agreement with the database server vendor. The fact that it's possible doesn't unburden you of any licensing obligations you may have.?