01-06-2009 10:59 PM
Is there a way to optimize ACT 10 Premium database into a smaller size?
The current database has 1000 entries but the size is almost 1 GB. It takes a long time to backup.
01-07-2009 09:42 AM
01-07-2009 12:02 PM
Is the database 1GB or the backup file 1GB?
If it's just the size of the backup file that's large check that you're not backing up a backup file. By default ACT! backs up everything in your Database Folder (dbname - database files). If you are not overwriting the previous backup each time, and especially if you are doing a scheduled backup which automatically creates a different file name each backup, you can find that the size of the backup file can increase exponentially. If that's the case change the backup location to somewhere outside the ACT Database folders.
01-09-2009 12:35 AM
Just to make sure I'm answering your Q correctly: I manually backup the database (using the backup sub menu in ACT) every night and name it with a date stamp. I also check the 4 boxes to backup all modules. I have moved the location of the backup a couple of times outside ACT's folder areas. I recently replaced the server and restored the database with no problems. The database serves 6 workstations. The size of the database has increased from almost 250 MB in Feb 2008 to almost 1 GB in Jan 2009. I have not compared the size of the database itself to the size of the zipped backup file that I'm concerned with.
01-09-2009 01:59 AM
As you have moved the backup location outside the ACT folders it is unlikely your database backup size is due to doing a backup of the backup.
Try doing a backup and uncheck the "Include Attachments" option and see what difference that makes.
On a general note, it is good practice to run Tools> Database Maintenance> Check and Repair at least once a week. I run this daily. It sorts out problems that might not be apparent in normal use and prevents bigger problems developing behind the scenes. It only takes a minute or so to run and helps to ensure that ACT! is running as quickly as possible.