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