Re: [PHP-DB] Database question

2003-07-03 Thread Jadiel Flores
This is right, maybe you can assign the db link to a session variable but this will work only for one specific user, but what would happen if you have around 100 users at the same time?? you will have 100 different connections to the db, and that will be slower. So, maybe you should try to avoi

Re: [PHP-DB] Database question

2003-07-03 Thread Paul Chvostek
On Thu, Jul 03, 2003 at 07:00:17AM -0700, Hardik Doshi wrote: > > 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 connec

[PHP-DB] Database question

2003-07-03 Thread 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

Re: [PHP-DB] Database question

2002-09-04 Thread Raquel Rice
On Tue, 20 Aug 2002 18:34:48 -0500 "Shiloh Madsen" <[EMAIL PROTECTED]> wrote: > I was wondering if there were any good documents out there about > good database design...I know the basics of creating tables, > setting data types and such, and now i want to know how to use it > to the best effect.

Re: [PHP-DB] Database question

2002-08-20 Thread Ignatius Reilly
4 AM Subject: [PHP-DB] Database question I was wondering if there were any good documents out there about good database design...I know the basics of creating tables, setting data types and such, and now i want to know how to use it to the best effect...generating logical, streamlined t

Re: [PHP-DB] Database question

2002-08-20 Thread Jason Wong
On Wednesday 21 August 2002 09:15, leo g. divinagracia iii wrote: > you can use either TEXT, MEDIUMTEXT or LONGTEXT. 64K, 16 million and 4 > billion bytes, respectively... > > the downside is the space taken up when the actual data is less than the > field size. The actual space taken up is onl

Re: [PHP-DB] Database question

2002-08-20 Thread leo g. divinagracia iii
Shiloh Madsen wrote: > I was wondering if there were any good documents out there about good database >design...I know the basics of creating tables, setting data types and such, and now i >want to know how to use it to the best effect...generating logical, streamlined >tables, etc. have you

[PHP-DB] Database question

2002-08-20 Thread Shiloh Madsen
I was wondering if there were any good documents out there about good database design...I know the basics of creating tables, setting data types and such, and now i want to know how to use it to the best effect...generating logical, streamlined tables, etc. As a side-related note, i have a fe