ASP.NET

Forum System - Where to Store Data?

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Oct 2009

Posts: 15

Reputation: anup.maverick is an unknown quantity at this point

Solved Threads: 0

anup.maverick anup.maverick is offline

Offline

Newbie Poster

Forum System - Where to Store Data?

Oct 22nd, 2009

HI,

I am creating a Forum System, this is a small system,

I want to know where to store the forum data(Messages posted by users),

Should I store it in SQL database or a Text File.

Please suggest something.

Thanx....

•

Join Date: Oct 2009

Posts: 1

Reputation: vipin_mishra99 is an unknown quantity at this point

Solved Threads: 1

vipin_mishra99 vipin_mishra99 is offline

Offline

Newbie Poster

Oct 22nd, 2009

u've 2 use sql to store

•

Join Date: Jun 2009

Posts: 452

Reputation: Ramesh S will become famous soon enough

Solved Threads: 82

Ramesh S

Offline

Posting Pro in Training

Oct 23rd, 2009

It would be better if you store the forum messages in a database system. So that you can easily store, retrieve the data with better performance.

If you store the forum data in a datbase, you can use the features specific to database systems such as security, indexing, stored precedures, views.

You can use SQL Server 2005/2008 Express Editions, MySQL for this purpose. You can also even use MS-Access which has limited features comparing with SQL Server and MySQL.

If you have a plan to use open source forum software, please check which database are supported by that software.

Last edited by Ramesh S; Oct 23rd, 2009 at 1:56 am.