Restricted connection number - how?
Posted: Wed 09 Mar 2011 12:39
Hi
Your components looks good, and I plan buy this packet after fulfilling additional tests.
But now I have one problem.
It is necessary to manage and restrict the number of connections for MS SQL Server.
I used early TAdoConnection, which bases upon MS OLE DB.
There is information in MSDN
---------------------------------------------------------------
In OLE DB resource pooling, the following formula determines the number of pools (where N is the number of pools, P is the number of processors, and C is the number of distinct sets of connection attributes on the system):
N = (P + 1) * C
----------------------------------------------------------------
That is - if my machine has 2 CPU then I can reach only 3 active TAdoQuery, connected for ONE TAdoConnection (if number of active MSSQL connections restricted of 1). If I add 4'th active query, then number of connections automatically become 2.
The question is - may I increase this amount of active queries with your components? For examle, may I use 10 active TMSQuery,connected to one TMSConnection, if number of active MSSQL connections = 1?
How can I do it?
Thank you
Your components looks good, and I plan buy this packet after fulfilling additional tests.
But now I have one problem.
It is necessary to manage and restrict the number of connections for MS SQL Server.
I used early TAdoConnection, which bases upon MS OLE DB.
There is information in MSDN
---------------------------------------------------------------
In OLE DB resource pooling, the following formula determines the number of pools (where N is the number of pools, P is the number of processors, and C is the number of distinct sets of connection attributes on the system):
N = (P + 1) * C
----------------------------------------------------------------
That is - if my machine has 2 CPU then I can reach only 3 active TAdoQuery, connected for ONE TAdoConnection (if number of active MSSQL connections restricted of 1). If I add 4'th active query, then number of connections automatically become 2.
The question is - may I increase this amount of active queries with your components? For examle, may I use 10 active TMSQuery,connected to one TMSConnection, if number of active MSSQL connections = 1?
How can I do it?
Thank you