| Re: 1.0.1 Beta Version [message #178 is a reply to message #177] |
Wed, 23 January 2002 04:23   |
Ilia
Messages: 13241
Registered: January 2002
Karma:
|
Senior Member
Administrator
Core Developer |
|
|
| Mack wrote on Tue, 22 January 2002 11:11 PM |
On code releases it would be much better to dump the annoying install script or have a version where a user can just untar and add the DB, change the paths and away he goes.
|
Well, the upgrade script we are working on will be really simple, it will ask only 1 question. The path to your GLOBALS.php file and nothing else.
For 1st time installs, I'll probably write a README.INSTALL file for people who do not wish to use any of the offered install scripts, I am not sure if that will make it in to the 1.0.1 release.
| Quote: |
Is there really any need to have messages saved outside the DB? As the forums are sql based.
|
There are several reasons why messages are not stored inside the DB.
Reading of the messages is quite a bit more memory efficient as well as speedier, especially since messages are not stored in individual files but rather in thread blocks separated by offsets.
When reading from files, FUDforum never stores more then 1 single message in memory at a time, while if we used mysql the SQL query would go and force php to store all the retrieved messages in memory while the script is running. Since php has about 2.5 times the memory overhead this can eat up quite a bit of memory or a set of messages with lots of text.
Importing of data is somewhat faster as you don't need to place large blocks of text into MySQL, you untar the files and you're done.
On most servers SQL is on a different hard drive from the one where the user files are kept, but using two drives you get quite a bit of speed improvement on large scale forums or servers with heavy IO traffic.
The actual message storage code is pretty modular, so it is possible withing maybe 1-2 hours to rewrite the current code base to use MySQL however, due to the reasons I've listed above I do not see it as a good idea.
FUDforum Core Developer
[Updated on: Wed, 23 January 2002 04:37] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]