application, session or single page data connection

[davidrobin]

The latter seems a bit excessive to me. This is probably a typical beginners question that gets asked a thousand times.

I'm just wondering if anyone has any suggestions on the best place to create a data connection. Should it be at application, session or on each individual page.

Thanks

[monte96]

Don't store ADO objects in the session object or the application object. The best thing to do is use an ActiveX dll that does your connecting and database activity.

When you store objects in the session object for example, it takes server resources to store it. But it will continue to store the object(s) until the session times out if the user browses to another site or just closes the browser. Multiply this by the number of concurrent users and you can see the potential problem.