Hi all,
In our project, they have used singleton pattern for connection handling part such that not more than one connection is open to the database. So, the same connection will be used again and again. will this actually affect memory usage in any way?
Because recently we had some issues and had to monitor the memory usage and it seemed to be increasing constanly.But when i explicitly closed the connection and opened it again (here, when i say closing the connection means sending it back to the connection pool), the memory seems to remain constant. I dont get the whole problem. Is using the same connection again and again for many operations going to cause a memory probelm? please explain.