| Author |
 Topic Search  Topic Options
|
ljamal 
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 16 April 2004 at 4:49pm |
|
Why are you storing things that are not likely to change in the database? Why not store configuration variable in a config file?
|
|
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2004 at 6:30pm |
makes it an online admin area controlled, means
if you want to change something you don't need to download, edit, upload and
it means you can change it anywhere you like just by loggin in....
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 16 April 2004 at 6:39pm |
|
you can edit a text file using the File System Object
and even if access to the FSO is disabled on server, how often do you really change those parameters?
The skins are not editable nor are the language files. At some point you have to weigh admin versus server performance and necessity, IMO configuration settings belong in a config file not stored in a database.
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 April 2004 at 12:41pm |
|
Nearly all setting in the admin area are now in application varibles.
These do occassionally get changed and store things like, forum name,
email setup, upload setup, forum email address, threads per page,
locked forums, avatar enabling, flash enabling, etc, etc.
So although these settings may only get changed once in awhile it is
important to keep these settings online and not in a cofig file as it
would make setting up and adminstrating the forum very difficult.
As these settings are not changed for each user and remain the same for
each user throughout the forum they are storred in application level
variabls to cut down on database calls.
|
|
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 April 2004 at 12:50pm |
|
Things such colors in the skin files get changed as well, but are available in the admin area. I'm also more likely to change the text in the language files as well, but those are not available in the admin area. However, things like site name, email configs, avatar, flash, etc that I'm not likely to change after set-up are available in the admin.
What is the deciding factor in having one over the other. Snitz and php boards use the same system so this is wide spread, but logically it makes little to no sense. Why use application variables to store information that in most cases constant?
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 April 2004 at 1:12pm |
|
Some things like forum configuration only use a hand full of database
fields and would be better in constents, but to make the forum easier
to setup they are available in the admin area.
Things like skins use many, many variables and would be a big hit on
performance and database size (Acces version) and so are not stored in
the database.
|
|
|
|
