Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT database optimazation

New Member
Posts: 4
Country: United States

ACT database optimazation

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.

Any help/direction?

Cheers,

Nissan

Tuned Listener
Posts: 21
Country: United States

Re: ACT database optimazation

Wow, we have about 13,729 entries, most of which have documents and e-mails attached.  That said, the database size when backed up is only 1.6 GB.  Have you tried the repair feature?
Silver Elite Contributor
Posts: 3,311
Country: United_Kingdom

Re: ACT database optimazation

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.

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk
New Member
Posts: 4
Country: United States

Re: ACT database optimazation

The database works OK so I did not think it needed repair. Have not had a good experience with the repair tools.

New Member
Posts: 4
Country: United States

Re: ACT database optimazation

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.

Silver Elite Contributor
Posts: 3,311
Country: United_Kingdom

Re: ACT database optimazation

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.

 

Jeff

Jeff Granger
UK ACT! Specialist and Trainer

ACT Training Throughout The UK
www. bigbluemarketing.co.uk