FUDforum: General Chit Chat » Messages in a file

Home » General » General Chit Chat » Messages in a file - why?

Show: Today's Messages :: Polls :: Message Navigator

Re: Messages in a file - why? [message #10768 is a reply to message #7181]

Mon, 09 June 2003 20:39

korebantic

Messages: 1
Registered: June 2003

Karma:

Junior Member

Olliver wrote on Sat, 09 November 2002 15:21

KVentz schrieb am Sam, 09 November 2002 01:59

I have found that FUD forum stores messages bodies separately from headers in a single text file and forum searches message by (start char, length) coordinates.

Why not to store messages bodies with headers in MySQL table? Was it made for productivity or something?

phpBB stores messages the way u described. The result is, that on high load the forum will become awfully slow, even if it would run with UNIX sockets. Saving messages into a file bypasses this restriction in favour of speed.
bye
Olliver

Insanity...Insanity

Even so, going with flat files has some serious drawbacks. What happens if the file gets corrupted? I can see that is far more likely to happen than with MySQL, especially if the server were to crash in the middle of a write. Modern day RDBMS protect you somewhat from that sort of thing. What data do you have to prove that this approach runs faster than MySQL using domain sockets.

Also, we have a custom message board system. Using this flat file format makes conversion for us far more difficult. It's quite unfortunate you made this decision. PhpBB all of a sudden looks a whole lot more appealing...

Report message to a moderator

[Message index]

		Messages in a file - why? By: KVentz on Sat, 09 November 2002 00:59
		Re: Messages in a file - why? By: hackie on Sat, 09 November 2002 07:45
		Re: Messages in a file - why? By: Olliver on Sat, 09 November 2002 20:21
		Re: Messages in a file - why? By: korebantic on Mon, 09 June 2003 20:39
		Re: Messages in a file - why? By: Ilia on Mon, 09 June 2003 20:59

Previous Topic:	Relavent php settings....
Next Topic:	selecting text

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 01 21:12:12 GMT 2024

Total time taken to generate the page: 0.05358 seconds