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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
swraman
Forum Commoner
Posts: 58
Joined: Thu Nov 06, 2008 12:33 am

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

Post 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
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

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

Post 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.
There are 10 types of people in this world, those who understand binary and those who don't
swraman
Forum Commoner
Posts: 58
Joined: Thu Nov 06, 2008 12:33 am

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

Post by swraman »

ok, Thanks.
Post Reply