PHP GENERAL 3 DATABASE QUESTION
Date: Thu, 3 Jul 2003 07:00:17 -0700 (PDT)

Subject: Database question
From: php_hardik@no-spam (Hardik Doshi)

Hi Group,

Currently i am connecting the underlying database server from every php page. To reduce the connection overhead i am thinking to store the PEAR DB object into the registry (session) at the time of user login.
Here i am connecting the Database only one time and rest of the time i am using the object stored in the memory. Even this is more helpful when the application is connecting more than one database..My application is getting feed from four different databases reside on two different servers.

I don't know what ever i am thinking is correct or not.. Please guide me if i am wrong anywhere and if any one of you have better idea then please disucss.

Thanks
Hardik Doshi
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Date: Thu, 03 Jul 2003 15:45:40 +0100

Subject: Re: Database question
From: pete@no-spam (Pete Morganic)
definately do NOT recommend this path-
Just make an include file at the top of each page
pete
Hardik Doshi wrote:
> Hi Group,
> > Currently i am connecting the underlying database > server from every php page. To reduce the connection > overhead i am thinking to store the PEAR DB object > into the registry (session) at the time of user login.
> Here i am connecting the Database only one time and > rest of the time i am using the object stored in the > memory. Even this is more helpful when the application > is connecting more than one database..My application > is getting feed from four different databases reside > on two different servers.
> > I don't know what ever i am thinking is correct or > not.. Please guide me if i am wrong anywhere and if > any one of you have better idea then please disucss.
> > Thanks > > Hardik Doshi > > __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com