Which one is better?(DB Connection)

[pashaa]

my program is client server application,before i use ADO and mssql,and create one connection in global variable.in this case i dont have problem.

now used Tmyquery and Tmyconnection component and mysql and like before one connection in global variable.but now after many request from users program will hang and answer to request slowly.

is this better(one connection for all procedures in program startup)?
or create connection in every procedure?


Thanks.

[pashaa]

can any one help me???

[ViktorV]

If you are using a multi-threaded application, then a separate connection (the TMyConnection component) per thread must be used.
You can get more information about performance improving when using our components at our website: https://www.devart.com/mydac/docs/index ... rmance.htm
In a single-threaded application, there should not be a problem when using one global connection.