No actually what i asked is Is it is better to open and close a conmnection for each database access or opening a connection at the beginning of a page, perform all operations and close it at the end of the page?
----- Original Message ----- From: "M. H. K." <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Saturday, September 28, 2002 7:25 PM Subject: Re: Which way is better? (ADO Connection) > Which one is better ? > > Using one check out register in the grocery store and have 100 clients get > lined up for their turn ? > > or > > Opening up a register where there is client gets in the lane !.. > > First is known to be "serialization" and it is evil. It is bound fail. > > Second is know to be "connection pooling". > > Cut it short and always open and close your connections at page level. > > And don't even think getting into storing your connections or recordsets > into Application level objects. > > As Rob says, connection pooling is the thing to read on. And > "serialization" is the other. > > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
