mySQL server connections - leave one open or use multiple?

[tommyboyau]

Hi guys,
Just a quick question here. What would be the best way to maintain a connection to a mySqlServer in an application?
Lets say this application has 10 users and would be used for 10 hours a day, retreiving and manipulation data all that time.

If i require a connection on different forms throughout the application what is the best way to do it.
- Maintain the same connection by passing it through, form to form
- Establish new connections each time?

Thanks for your help.

Tom

 

[petermeachem]

I just keep one global connection. Open it when the programme starts and close it when it stops.

http://www.accuflight.co.uk

http://www.lettersdirect.co.uk

http://www.trelliscoaching.com

http://www.fengshuimarketingcenter.com

http://www.ourhouseinportugal.co.uk

 

[BobRodes]

Another thought is to investigate COM+ connection pooling.

Bob