You should try to avoid opening and closing connections any more than necessary.

This is good advice, regardless of whether there's a memory leak or not. Opening and closing connections can be very time-consuming, particularly if the database is remote.