Re: [PHP-DB] how many databases should I create

2004-10-18 Thread M Saleh EG
> > From: Norland, Martin [mailto:[EMAIL PROTECTED] > > Sent: 18 October 2004 22:12 > > To: [EMAIL PROTECTED] > > Subject: RE: [PHP-DB] how many databases should I create > > > > > > You're talking two different users here - in my instance, I was talkin

RE: [PHP-DB] how many databases should I create

2004-10-18 Thread Graham Cossey
is of course MY preference for MY application, just airing my thoughts Graham > -Original Message- > From: Norland, Martin [mailto:[EMAIL PROTECTED] > Sent: 18 October 2004 22:12 > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] how many databases should I create > > >

RE: [PHP-DB] how many databases should I create

2004-10-18 Thread Norland, Martin
;Sent: Monday, October 18, 2004 4:02 PM >To: [EMAIL PROTECTED] >Subject: Re: [PHP-DB] how many databases should I create .. .. >shouldn't a good rdbms take care of that though (with reasonable security measures)? can't you >get fine grained user privs, at least with a proper

Re: [PHP-DB] how many databases should I create

2004-10-18 Thread Antoine
On Mon, 18 Oct 2004 14:53:41 -0500, Norland, Martin <[EMAIL PROTECTED]> wrote: > That all really depends on you. I would certainly say that, in general, > any given database should only have one users table (with a separate > table holding roles, permissions, etc.) In all likelihood - if all of >

RE: [PHP-DB] how many databases should I create

2004-10-18 Thread Norland, Martin
is email do not necessarily represent those of St. Jude Children's Research Hospital. -Original Message- From: Perry, Matthew (Fire Marshal's Office) [mailto:[EMAIL PROTECTED] Sent: Monday, October 18, 2004 2:38 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] how many databases should I c

Re: [PHP-DB] how many databases should I create

2004-10-18 Thread Jeffrey Moss
you can move different databases around onto different partitions if they get too big. -Jeff - Original Message - From: "Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 18, 2004 1:37 PM Subject: [PHP-DB]

[PHP-DB] how many databases should I create

2004-10-18 Thread Perry, Matthew (Fire Marshal's Office)
I am developing a variety of different web based systems including inventory, payroll, incident reports etc. Should I create a new database for each project category or one huge database with every table I will ever use in it? -Matt