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

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 connecting

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

Re: [PHP-DB] Database question

2002-08-21 Thread Ignatius Reilly
A really good starting-level textbook is Fabian Pascal's Practical issues in database management. My warm recommendation. It will give you a decent theoretical understanding as well as helping you designing your DB in order to avoid the most usual design mistakes. You will find there VERY

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 got

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 only a