In case of customisation we need to initiate read and write connection in our .phtml file.
Should we manually close these connection at the end of file? or Magento self handles it?
In my case I have several time called read connections in my templates now I am feeling there must be any other solutions to handle this.
If I use multiple time Read Connection, would it may load up my database or server?
Somewhere I found it to be used.
$db = Mage::getSingleton('core/resource')->getConnection('core_read');
You can close the connection with this:
And then re-open it with this
Should I do this for handling multiple and concurrent connections?
Let me know if any suggestion.