Page 1 of 1
how many tables...
Posted: Wed Sep 21, 2005 2:18 pm
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]
Posted: Wed Sep 21, 2005 2:24 pm
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..
Posted: Wed Sep 21, 2005 2:27 pm
by andrei.mita
ok, thanks