flat-file forums
Moderator: General Moderators
-
generalm10
- Forum Newbie
- Posts: 4
- Joined: Wed Apr 24, 2002 1:05 am
flat-file forums
I have some questions about flat-file databasing for forums.
The website we are creating will allow our users to create their own forums, using software that we have written in PHP. Each forum will be given its own sub-domain and directory. Our software right now just parses tiny text files, one for each topic inside forum folders, so they never get very big but have the capability to become numerous.
Would, say, 1000 of these forums running on a shared server bog down the server resources? How can we test this and see if our software is stressful on the server? Is there a way to see how much information is being processed when a script is run? Is there a more effecient way of databasing this?
Thanks - Alex B.
The website we are creating will allow our users to create their own forums, using software that we have written in PHP. Each forum will be given its own sub-domain and directory. Our software right now just parses tiny text files, one for each topic inside forum folders, so they never get very big but have the capability to become numerous.
Would, say, 1000 of these forums running on a shared server bog down the server resources? How can we test this and see if our software is stressful on the server? Is there a way to see how much information is being processed when a script is run? Is there a more effecient way of databasing this?
Thanks - Alex B.
You could start by storing the data in a real database. PHP has great support built in for many databases, including free ones such as MySQL and PostgreSQL. The people who made those databases have put a lot of effort into making them faster and easier to use than regular flat files. This would help performance greatly.
As far as load testing, you need to build your applications first. There are a few free tools that you can have run queries against your website. They'll just pound the heck out of it and give you a report about how many users you will be able to handle at once and so on. check out http://www.freshmeat.net and do a search for load testing.[/url]
As far as load testing, you need to build your applications first. There are a few free tools that you can have run queries against your website. They'll just pound the heck out of it and give you a report about how many users you will be able to handle at once and so on. check out http://www.freshmeat.net and do a search for load testing.[/url]
-
generalm10
- Forum Newbie
- Posts: 4
- Joined: Wed Apr 24, 2002 1:05 am
okay
so you think it would be safe to store multiple forums' data in one mysql database? im talking about hundreds, maybe thousands of message boards running from the same database. would this slow things down?
It really also depends on the activity.
I can have a 1000 forums running.....and no activity. You need to consider what load you will have.
The best answer would be something hardware wise. You keep about 150 forums on each server, and get a new server for every so many people.
In fact, you could have a web server, a file server, and a database server.
Need more speed, throw another server into the loop, and let it handle the load.
This, of course, is something you should talk to your sysadmin about.
I can have a 1000 forums running.....and no activity. You need to consider what load you will have.
The best answer would be something hardware wise. You keep about 150 forums on each server, and get a new server for every so many people.
In fact, you could have a web server, a file server, and a database server.
Need more speed, throw another server into the loop, and let it handle the load.
This, of course, is something you should talk to your sysadmin about.
-
generalm10
- Forum Newbie
- Posts: 4
- Joined: Wed Apr 24, 2002 1:05 am
It's definately possible to store multiple forums' data in the same database as long as you design the database correctly. It's actually the way I would recommend. You can load balance database servers later when you have more of a budget for more hardware if you design it with this method. If the forums are small, you could fit quite a few on the same server. You just have to see what your load is like when you get there, or if you have a good idea now, it shouldn't be to hard to calculate.
-
generalm10
- Forum Newbie
- Posts: 4
- Joined: Wed Apr 24, 2002 1:05 am
The solution?
Did anyone ever come up with a clear solution to this question? For a website with 1000 small individual forums, would it be better to use a flat file solution or a single database? Thanks!
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Next time, could you maybe post a new thread with a link to the old thread so we don't bring back threads that have been dormant for 5 years and 7 months?
Based on the thread, there was no solution offered other than trying to database them. It would be my recommendation as well, as there is no reason to overload the filesystem with that many hits to the files. This is just my opinion.
EDIT | Man, I really need to start looking at dates better. Seeing as this thread has been dead for quite some time, I am going to lock it. Contact a mod to unlock it if you think there is sufficient reason to have it unlocked.
Based on the thread, there was no solution offered other than trying to database them. It would be my recommendation as well, as there is no reason to overload the filesystem with that many hits to the files. This is just my opinion.
EDIT | Man, I really need to start looking at dates better. Seeing as this thread has been dead for quite some time, I am going to lock it. Contact a mod to unlock it if you think there is sufficient reason to have it unlocked.