Hi! 

    I have designed some asp pages. We are trying to devlope data 

navigation kind of pages. In those forms we have to hit database (Oracle)

very frequently. Page having submit kind of buttons, so, when ever I

request for next or prev data our page used to hit database and opens one

new connection. 

    What I want is, Global connection which I wants to put in Global file

and I want to refer it thru all pages. So, can I open such a global

connection in .asa (global) file. Ofcourse I will open it in On

Application_Onstart event of global file. 

    Or is there any another way to avoid multiple connections.

Regards

You should never store ADO objects in Application scope. OLE DB implements

connection pooling, so it's far more efficient to open and close the

conenction in each ASP page.



Dave



"amit" wrote in message news:2006@a..._databases...

>

> Hi!

>     I have designed some asp pages. We are trying to devlope data

> navigation kind of pages. In those forms we have to hit database (Oracle)

> very frequently. Page having submit kind of buttons, so, when ever I

> request for next or prev data our page used to hit database and opens one

> new connection.

>     What I want is, Global connection which I wants to put in Global file

> and I want to refer it thru all pages. So, can I open such a global

> connection in .asa (global) file. Ofcourse I will open it in On

> Application_Onstart event of global file.

>     Or is there any another way to avoid multiple connections.

> Regards

>

>

You could read the chapter that covers connection 

pooling. It has some interesting possibilites.

I've learned from experience that opening a global

connection in the global.asa will have serious 

performance implications. I solved this by creating

a few (rather large) disconnected record sets in 

the application_onstart so I could get at the data 

without actually having an open connection.

This depends of cource on the needs of the specific

application but these type of applications, when 

looked at from the vieuw point of a (relatively 

large) number of clients, are usually just getting

more or less the same data out of the database

over and over, so you might as wel save it somewhere

in the application instead of asking for it every

time.



Regards



-----Original Message-----

From: amit ]

Sent: zaterdag 22 april 2000 15:40

To: ASP Databases

Subject: [asp_databases] Connection Problem





Hi! 

    I have designed some asp pages. We are trying to devlope data 

navigation kind of pages. In those forms we have to hit database (Oracle)

very frequently. Page having submit kind of buttons, so, when ever I

request for next or prev data our page used to hit database and opens one

new connection. 

    What I want is, Global connection which I wants to put in Global file

and I want to refer it thru all pages. So, can I open such a global

connection in .asa (global) file. Ofcourse I will open it in On

Application_Onstart event of global file. 

    Or is there any another way to avoid multiple connections.

Regards



---

You are currently subscribed to asp_databases