Re: Tables vs. databases

On 6/10/06, Antonio Bassinger <antonio.bassinger@gmail.com> 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?

On top of the replies you already have you should read these pages: http://arjen-lentz.livejournal.com/66547.html http://bobfield.blogspot.com/2006/03/million-tables.html Though you're not talking about those sort of numbers, you need to be aware of those limitations (there were more posts on planetmysql.org about this but I can't find the original page). -- Postgresql & php tutorials http://www.designmagick.com/