how many tables...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
andrei.mita
Forum Commoner
Posts: 65
Joined: Sun May 08, 2005 4:06 am
Location: Barlad/Romania

how many tables...

Post by andrei.mita »

is there any problem if i use more then 200 tabels into a db? shoult i try and use less? i want to creat a kind of blog for a comunity and i thought that I should creat a tables for every user in which to store their data. the comunity offers a personal diary for each user.[/url]
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

a table for each user is very often a no-no.

Under "normalized" tables, you'd have a single table for all user data, a single table of all diary entries, a table of all "friends", so on and so forth..

basically you have a table for each "type" of data you store..
andrei.mita
Forum Commoner
Posts: 65
Joined: Sun May 08, 2005 4:06 am
Location: Barlad/Romania

Post by andrei.mita »

ok, thanks
Post Reply