This seems like a simple question but i cannot find a solid answer anywhere.
Im in the middle of streamlining our web application for use on local network and external use.
When a form loads there are usually several blocks of code that run.
Fetch Title From Database
Fetch Items For Combo Lists To Populate
Fetch Saved Data To Insert Into Fields
NOW obviously there is some processing inbetween especially step 2 of filling combo lists which can contain anywhere between 1 - 1000 selections (not practical but it is the users choice if they want 1000)
I understand opening a connection to a database is a costly server action processing wise and also is time consuming. So is it better for me to maintain one connection to pass to these seperate methods on page load or open a new instance-return data-close connection inside each method.