DB Connection with Application/Page Scope
if a website is getting 100+ DB connection and recordset calls a minute, would it be better to set up 1 application level database connection strings and about 10 application level recordset objects that would handle 90% of the traffic? or would it be better to just open the database everytime i need it.
-----------------------------------------
Inigo: You have a great gift for rhyme.
Fezzik: Yes, yes, some of the time.
Vizzini: Enough of that.
Inigo: Fezzik, are there rocks ahead?
Fezzik: If there are, we'll all be dead.
Vizzini: No more rhymes now, I mean it!
Fezzik: Anybody want a peanut?
__________________
-----------------------------------------
Inigo: You have a great gift for rhyme.
Fezzik: Yes, yes, some of the time.
Vizzini: Enough of that.
Inigo: Fezzik, are there rocks ahead?
Fezzik: If there are, we\'ll all be dead.
Vizzini: No more rhymes now, I mean it!
Fezzik: Anybody want a peanut?
|
