No you misunderstand me.

I don't think opening a database connection in the Session object is very efficient. If you have a large amount of traffic on the site then you could get problems like dropped connections - not because of the Session but because of the large numbers of open database connections.

When I said local database connection I meant opening the connection just before you need it and closing it just after.

How many people use your site?

DJ