Re: Tables vs. databases

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 10000 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 I >realize that I may land in trouble with such a huge database. Would it be >better to have a separate database for each subscriber? > >Which approach is better, many tables in 1 database, or many databases with >1 or max 2 tables? > >Kindly suggest with pros and cons of each. > >Thanks & Regards, >Bassinger You might also ask the mysql group. http://lists.nyphp.org/mailman/listinfo/mysql hth's tedd -- ------------------------------------------------------------------------------------ http://sperling.com http://ancientstones.com http://earthstones.com