On 09/06/06, Antonio Bassinger <antonio.bassinger@xxxxxxxxx> 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? First off, why does each subscriber have their own table rather than being one record in a single subscribers table? I think you may need to think about the database design - the relational structure.
-- http://www.web-buddha.co.uk dynamic web programming from Reigate, Surrey UK (php, mysql, xhtml, css) look out for project karma, our new venture, coming soon!