in reply to Re: Tomcat, CGI scripts and DBI connection persistencein thread Tomcat, CGI scripts and DBI connection persistence
There would be overhead, but how do the cgi-bin/<scriptname>.pl programs communicate with the DB? That has all the same overhead, plus the database's authentication.
If the individual programs typically run a small number of queries per invocation then the overhead of DB authentication is relatively more significant.
Also, if the website is heavily used the DB might be "happier" with a small number of connections making many queries vs many connections making few queries each.
.desrever si txet eritne ehT
.backwards are (letters the not but) words the Only
ehT sdrow era ni redro, tub eht srettel era eht rehto yaw.
Who ndees baacdkrws wehn you have Tceilmopgyya?
?wdors reeersvd up meixd about How
.tusnnmihep rof nuttolg a m'I
Results (441 votes). Check out past polls.