[thelist] Connection Inefficiency

[Jay Blanchard]

[snip]
p.s. scripting language is indifferent here...
[/snip]

Actually, that is not true. Some languages...such as PHP....have
persistent database connections (with certain databases) and do a good
job of managing connections. Others, such as VBScript have
"connect-time" only database connections.

Also the database itself will either have or not have the capability to
accept a persistent connection. 

In many cases it would be more inefficient to allow the connection to
remain open as each open connection consumes resources.

YMMV