| Re: FUD Question [message #668 is a reply to message #657] |
Fri, 22 February 2002 02:27   |
hackie
Messages: 177
Registered: January 2002
Karma:
|
Senior Member
Core Developer |
|
|
| B@rt wrote on Fri, 22 February 2002 1:22 AM |
Hi all,
I couldn't seem to find a place for FUD user questions, so I'm hoping someone is willing to help me here.. Here's my question:
At this moment, we are running phorumon a busy community site (100k pageviews/day; > 100k messages in the database). I've been looking for a new forum server and FUD definately has all the features that I am looking for. BUT....
The fact that so many items are stored on the filesystem instead of in the database (message bodies, user settings) scares the heck out of me. For example, it seems like each thread gets stored in /data/messages. What happens when you have more than, say, 1000 threads? Are they all stored in the same subdirectory? Or does FUD create 'buckets' like for example message 1-500, 501-1000 etc. I'm afraid that I'm not sure if our operating system (FreeBSD) can handle that.
Is there something I've missed while installing? Maybe it's possible to force everything to be stored in the database?
Does anyone else here have experience with running FUD on a large site?
Thx,
B@rt
|
Well, we think it is better to store the message bodies on the file system for a rather large amount of reasons, prot' there listed some of them, there are more.
Consider, first of all there is of course file system caching of files, while MySQL not chaching BLOBS/TEXT. It gets more complicated, consider the overhead of storing such large chunks of data in the database, well, to retrieve it you would have to transfer all this data over a socket, sure you can make it faster by using UNIX sockets, but still, that is a huge amount of pointless overhead, as opposed to the file system!
There is a disadvantage to the file system storing of course, that is, you can't run the forum web server and store the message bodies on a different machine (unless you use NFS of course), but we think it's a fine trade off.
MOREOVER! Early version of FUDforum did use DB for storing bodies, but we converted it for performance considerations to the FS code you see today. It took us about 15MIN  ... So, if you want to convert FUDforum to use the DB to store bodies, it would take you all of about.. oh.. 15min and a small script to read them back in.....
In addition the only things stored in those files are message bodies, the messages themselves are of course in the database.
cc intelligence.c -o intelligence
$ ./intelligence
Segmentation fault
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
) 1 Vote
]