473,406 Members | 2,710 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Forum Query

Hi all,

I'm just curious to how forums store the body of messages. Is it just as
text in a DB? This seems to me as if the DB would take on gigantic
proportions if a lot of people posted regularly. Or is there another trick
which is used? I was thinking perhaps saving messages as a text file, with
the Db storing a link to the message and fopen used to draw it out. Not sure
what the response time to such an action would be when applied to a lot of
messages. I know the messages would still take up the same amount of disk
space, but I'm guessing the DB would be a lot smaller and easier to
maintain...

As I say this is more of a curiosity then anything else :)
Chris
Jul 16 '05 #1
2 1795
On Sun, 20 Jul 2003 18:06:16 +0000, ^MisterJingo^ wrote:
Hi all,

I'm just curious to how forums store the body of messages. Is it just as
text in a DB? This seems to me as if the DB would take on gigantic
proportions if a lot of people posted regularly. Or is there another trick
which is used? I was thinking perhaps saving messages as a text file, with
the Db storing a link to the message and fopen used to draw it out. Not sure
what the response time to such an action would be when applied to a lot of
messages. I know the messages would still take up the same amount of disk
space, but I'm guessing the DB would be a lot smaller and easier to
maintain...

As I say this is more of a curiosity then anything else :)
Chris


Hey :)

As far as I know, most forums put the text in the Db.
That's the way I do it too btw.
The size of a Db doesn't matter that much as long as you're not doing a
wildcard search on that field without setting indexes first.
When you use indexes it doesn't matter what you do, it will be quick.

Greetz,

Michiel
Jul 16 '05 #2
With total disregard for any kind of safety measures
"^MisterJingo^" <mi*********@keysurf.net> leapt forth and uttered:
Hi all,

I'm just curious to how forums store the body of messages. Is
it just as
text in a DB? This seems to me as if the DB would take on
gigantic proportions if a lot of people posted regularly. Or is
there another trick which is used? I was thinking perhaps saving
messages as a text file, with the Db storing a link to the
message and fopen used to draw it out. Not sure what the
response time to such an action would be when applied to a lot
of messages. I know the messages would still take up the same
amount of disk space, but I'm guessing the DB would be a lot
smaller and easier to maintain...

As I say this is more of a curiosity then anything else :)
Chris


ASCII text takes up very little storage space. And the speed and
efficiency gains from using a proper database far outweigh any disk
space considerations. Hard disk space is by far the cheapest
commodity in any hosting arrangement anyway.

--
There is no signature.....
Jul 16 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: Michael Trojanek | last post by:
Hi there. This is not really a PHP-question, but I think you guys should know that ;-) I am building a forum for a friend of mine using Borland Delphi's WebServices. It will be a rather small...
6
by: Daan | last post by:
Hello all, I have attempted to write my own forum using PHP and MySQL. It works, but the efficiency is far from ideal. It takes a long time to load e.g. the list with threads in a certain forum....
0
by: Robert Oschler | last post by:
Hello all, I have set up a forum dedicated to WordNet Developers. I just added a section for Python developers that are using PyWordNet or other Python based WordNet interface modules or code. ...
14
by: Matt | last post by:
Any progammers looking for a killer app to develop? How about a voice enabled forum? One of the most powerful, exciting, and engrossing experiences on the Internet is the Forum. The first great...
4
by: frizzle | last post by:
Hi there, Still building my forum. I have a certain mysql-query i just can't figure out. These are my tables (simplified): categories -> id, description forums -> id, cat_id,...
0
by: Billie Boy | last post by:
Hi to all. I’m new here and am coming to you from Melbourne Australia. So a big HELLO 2 ALL. Thanx for having me here. TOP forum you guy's have here! Can anyone answer my problem? Please. ...
1
PEB
by: PEB | last post by:
POSTING GUIDELINES Please follow these guidelines when posting questions Post your question in a relevant forum Do NOT PM questions to individual experts - This is not fair on them and...
3
by: kang jia | last post by:
hi i am doing reply page for forum, users can reply for the specific topic they would like to reply. Firstly of all, when click the topic name in topic page. i will redirect them to reply page....
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.