Thought I would share some benchmark results, took PHP code that does the following:
include file
mysql_connect
mysql_select_db
And repeated 2000 times, on this shared host, it took just 0.09 seconds.
So there is very little overhead in repeatedly connecting to a database.