Options.MultipleConnections
Posted: Mon 07 Jun 2021 07:23
Hello,
We just upgraded the PgDac component in our Delphi projects to the latest version.
I noticed that PgDac now creates extra db connnections implicitly. PG connections are quite expensive, so I got to investigating why these connections are created. I found info about a new "Options.MultipleConnections" property in your documentation.
The documentation says: Use the MultipleConnections property to enable or disable the creation of an additional internal connection for TPgQuery, when necessary. The default value is True.
Can you tell my what this property does exactly? And why you need it?
I want to disable it, since we don't want all these extra db connections. We want to minimize the number of db connections.
But I do want to know what I lose when I disable it.
I hope you can explain what you use the extra connections for and what we lose if we disable the property.
Thanks in advance!
We just upgraded the PgDac component in our Delphi projects to the latest version.
I noticed that PgDac now creates extra db connnections implicitly. PG connections are quite expensive, so I got to investigating why these connections are created. I found info about a new "Options.MultipleConnections" property in your documentation.
The documentation says: Use the MultipleConnections property to enable or disable the creation of an additional internal connection for TPgQuery, when necessary. The default value is True.
Can you tell my what this property does exactly? And why you need it?
I want to disable it, since we don't want all these extra db connections. We want to minimize the number of db connections.
But I do want to know what I lose when I disable it.
I hope you can explain what you use the extra connections for and what we lose if we disable the property.
Thanks in advance!