|Administrator Help - RC v3.3|
Chapter - 13.0 Maintaining Healthy Database
Regardless of the type of database (MS Access, MSSQL, MySQL), it tends to grow in size. There are two types of records, which influence database growth - temporary and permanent records.
Permanent – relate to the user accounts and ads posted by clients.
Temporary – relate to statistics logs.
Impact of Permanent records in database for the most part cannot be controlled. More people visit your site – more accounts and ads created. Faster the database would grow in size. The only way to control amount of posted ads is to delete expired ads after certain date.
Temporary records on the other hand could and must be controlled to prevent fast database grow.
Below some recommendations, which would help to control excessive database grow and keep database neat and healthy.
Special care for MS Access database
Records in database constantly added and deleted. Some of the records deleted automatically and some deleted manually. The most automated routine at classified is Sessions maintenance, where new sessions are added to database with each new visitor and older sessions removed. While MSSQL and MySQL database reallocate space occupied by deleted records, MS Access database does not. In time, MS Access database (cldb.mdb file in db folder) might grow enormously and take up large amount of space on a disk. This would also affect the site performance. Even if you constantly clear logs, the size of the MS Access database would NOT be reduces.
The only way to reallocate deleted records space in cldb.mdb is to use Compact Database in Global Manager. Do Compact MS Access database at least once a month or after removing a large amount of records by clearing logs for instance. Compacting not only reduces the size of database, but also might repair some internal inconsistencies in database. While using Compact Database, a backup of the database always created in db/backup folder.
|©2003-2010 Rapid Classified v3.3 GA Soft|