Generally it is more efficient to connect once. Each time you're connecting to database you're spending some time and resources. On the other hand if your process sending one request to database in ten minutes, it may be better to establish a new connection for every request.