Page 1 of 1

Is it bad to have a growing number of tables for a forum sci

Posted: Fri Jan 16, 2009 10:36 am
by swraman
I am writing a forum script using PGSql, and I am new to PGSql.

I am planning on having each thread that is started be a new table in the databae. Is this a bad idea? In the sense that there are potentially an infinite number of tables that will be generated? In other words, is it better to have the "possibly infinitley growing" data structure be a Table or a row?

Thanks

Re: Is it bad to have a growing number of tables for a forum sci

Posted: Fri Jan 16, 2009 10:57 am
by VladSun
swraman wrote:I am writing a forum script using PGSql, and I am new to PGSql.

I am planning on having each thread that is started be a new table in the databae. Is this a bad idea? In the sense that there are potentially an infinite number of tables that will be generated? In other words, is it better to have the "possibly infinitley growing" data structure be a Table or a row?

Thanks
Yes, it's a bad idea.

You need several tables - e.g.:
- users;
- forum sections;
- threads;
- posts;

with relations between them.

Re: Is it bad to have a growing number of tables for a forum sci

Posted: Fri Jan 16, 2009 12:08 pm
by swraman
ok, Thanks.