Connection

[kotkot310]

Dears ,

i have an application witch connect to the SQLserver DB every 10 Second
so my question is which is the best from the below options :
1 ) open a new connection every 10 second and close it after finish
2 ) Open the connection when the application open and close only when the app close

so i am waiting for your repy

thanks

[travishein]

2 ) Open the connection when the application open and close only when the app close

[kotkot310]

Thank you for Reply but may i ask why the second is better than the first?

[RamyaSivakanth]

Database connections are costly and it hits the performance if u keep it open for long.

[kotkot310]

thank you ramya for your reply
But open connections and close will not be costly to???