Discus Home Page | Knowledge Center | Administration Instructions |
|
Options Manager -- Last Access Information This option is set from the Profiles tab of the Options Manager interface. Background Information Discus and Discus Pro record, in the user database, the "last access" time of a user. This is used to display information in the User Manager, and in Discus Pro, as a basis for filtering the User Manager list based on access time and for display in the user interface member list. To record a "last access" time in the user database, Discus must perform an update of that database whenever a user accesses the board (to record the new time). If a MySQL database is used with Discus Pro, the update operation is quick and safe, as database systems such as MySQL are optimized to store large quantities of information and to allow this information to be updated easily. However, if a flat text file is being used, to update the one bit of information (user access time), it is necessary to read the user file into memory, make the manipulation, and write the user file back out. Continuous reading and writing of the user file in this way makes it susceptible to corruption in the case of a server crash. Writing to the user file has another disadvantage - each write requires that the user database be locked. While the database is updated to record a last access time, no other processes can access the user database at this time. It is for this reason that a "File Locking Error" on the users.txt file may be frequently seen on busy boards with many members. This setting allows you to control how often your user database is updated with the user's access time. The issue here is a tradeoff between accuracy of the "last access" time and speed and reliability of your board (improving performance by reducing the number of file writes). Options Explained
What about MySQL? If you are using Discus Pro and have the MySQL database back-end enabled, this option will not appear in the Options Manager. Because MySQL is so reliable and fast at making an update of user information, the equivalent of "Upon each access" as noted above is performed. However, this will not create much additional load on the server, and will not result in file locking errors, since MySQL is designed to accept and manage multiple connections to the same database. Copyright © 2002, DiscusWare, LLC, all rights reserved |