Is it better to just open a connection at the top of the page and close it at the end, using only one connection, but leaving it open for the entire processing of the page,? Or is it better to open and close connections as needed, only having them open for as long as you need them? Or does it even matter either way? Right now, I only open a connection as needed and close it after I am done with it (usually both inside a function returing the resultset). Should I maybe consider going the other route?
