Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Compact Database
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

leatherlips
Senior Member

USA
1838 Posts

Posted - 15 August 2005 :  21:04:37  Show Profile  Visit leatherlips's Homepage
What does compacting the database do? When should I need to do it?

Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 15 August 2005 :  22:46:58  Show Profile  Send ruirib a Yahoo! Message
Reduces database size and improves performance. If you feel forum performance is going down a bit, do it, or after doing something like topic archiving.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 16 August 2005 :  04:18:24  Show Profile  Visit HuwR's Homepage
compacting will only help if you have deleted lots of stuff in your database, compacting after an archive won't make that much difference since you are not deleting them.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 August 2005 :  05:14:28  Show Profile  Send ruirib a Yahoo! Message
quote:
Originally posted by HuwR

compacting will only help if you have deleted lots of stuff in your database, compacting after an archive won't make that much difference since you are not deleting them.


When you archive you delete topics and replies. If you do not compact, the free space at those tables won't be reclaimed.


Snitz 3.4 Readme | Like the support? Support Snitz too

Edited by - ruirib on 16 August 2005 05:14:45
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.4 seconds. Powered By: Snitz Forums 2000 Version 3.4.07