As already mentioned, we have to access the database using a connection pool. FireDAC has the concept of connection definition. A connection definition describes how to store and use FireDAC connection parameters, and what a connection definition means. To specify connection parameters, an application must use a connection definition. The connection definition is a set of parameters. Depending on the kind of connection definition, a connection may also be pooled.
FireDAC supports three definition types:
Connection |
Definition |
Temporary |
This has no name, is not stored in a connection definition file, and is not managed by the FDManager. It is defined directly on TFDConnection component, and cannot be used as pooled. ... |