Tables vs. databases

From: Date: Fri, 09 Jun 2006 17:10:46 +0000
Subject: Tables vs. databases
Groups: php.general 
Request: Send a blank email to php-general+get-237705@lists.php.net to get a copy of this message
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

« previous php.general (#237705) next »