[PHP] Tables vs. databases

2006-06-09 Thread Antonio Bassinger
Hi gang, Situation: I've a HTTP server. I intend to run a file upload service. There could be up to 1 subscribers. Each saving files up to 10 MB. I made a proof-of-concept service using PHP & MySQL, where there is a single database, but many tables - a unique table for each subscriber. But

Re: [PHP] Tables vs. databases

2006-06-09 Thread Dave Goodchild
On 09/06/06, Antonio Bassinger <[EMAIL PROTECTED]> wrote: Hi gang, Situation: I've a HTTP server. I intend to run a file upload service. There could be up to 1 subscribers. Each saving files up to 10 MB. I made a proof-of-concept service using PHP & MySQL, where there is a single database

Re: [PHP] Tables vs. databases

2006-06-09 Thread Jochem Maas
Antonio Bassinger wrote: > Hi gang, > > Situation: > > I've a HTTP server. I intend to run a file upload service. There could > be up > to 1 subscribers. Each saving files up to 10 MB. > > I made a proof-of-concept service using PHP & MySQL, where there is a > single > database, but many tab

Re: [PHP] Tables vs. databases

2006-06-09 Thread Richard Lynch
On Fri, June 9, 2006 12:10 pm, Antonio Bassinger wrote: > > I've a HTTP server. I intend to run a file upload service. There could > be up > to 1 subscribers. Each saving files up to 10 MB. > > I made a proof-of-concept service using PHP & MySQL, where there is a > single > database, but many t

Re: [PHP] Tables vs. databases

2006-06-09 Thread chris smith
On 6/10/06, Antonio Bassinger <[EMAIL PROTECTED]> wrote: Hi gang, Situation: I've a HTTP server. I intend to run a file upload service. There could be up to 1 subscribers. Each saving files up to 10 MB. I made a proof-of-concept service using PHP & MySQL, where there is a single database,

Re: [PHP] Tables vs. databases

2006-06-09 Thread Lester Caine
Antonio Bassinger wrote: I've a HTTP server. I intend to run a file upload service. There could be up to 1 subscribers. Each saving files up to 10 MB. I made a proof-of-concept service using PHP & MySQL, where there is a single database, but many tables - a unique table for each subscrib

Re: [PHP] Tables vs. databases

2006-06-10 Thread tedd
At 10:40 PM +0530 6/9/06, Antonio Bassinger wrote: >Hi gang, > >Situation: > >I've a HTTP server. I intend to run a file upload service. There could be up >to 1 subscribers. Each saving files up to 10 MB. > >I made a proof-of-concept service using PHP & MySQL, where there is a single >database,

Re: [PHP] Tables vs. databases

2006-06-10 Thread Anthony Ettinger
On 6/9/06, Antonio Bassinger <[EMAIL PROTECTED]> wrote: Hi gang, Situation: I've a HTTP server. I intend to run a file upload service. There could be up to 1 subscribers. Each saving files up to 10 MB. I made a proof-of-concept service using PHP & MySQL, where there is a single database, b

Re: [PHP] Tables vs. databases

2006-06-12 Thread Antonio Bassinger
Thanks to All who suggested solutions or pointed errors in my existing approach. Most seem to suggest having 1 database and 1-2 tables. So let me confirm: 1 table with million records are ok. But what of the size of the table? 10,000 * 10 MB = 100 GB! If the upload limit is to be notched up 100

Re: [PHP] Tables vs. databases

2006-06-12 Thread Jochem Maas
Antonio Bassinger wrote: > Thanks to All who suggested solutions or pointed errors in my existing > approach. > Most seem to suggest having 1 database and 1-2 tables. So let me confirm: > > 1 table with million records are ok. But what of the size of the table? > > 10,000 * 10 MB = 100 GB! put y