Community
Showing results for 
Search instead for 
Do you mean 
Reply

Speed Issues ACT! 2010?

New Member
Posts: 4
Country: USA

Speed Issues ACT! 2010?

Anyone out there with 117,000 + contact database, 20 + users,  that has migrated from ACT! 08 to 2010 and upgraded SQL experiencing any increase in speed of program?

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Speed Issues ACT! 2010?

ACT! 2010 (now ACT! 2011) is faster than ACT! 2008 (10.0)

But much will depend on the hardware (server/workstations) ... not processor so much, but RAM and HDD speed in RPM
New Member
Posts: 4
Country: USA

Re: Speed Issues ACT! 2010?

Thanks Mike. It appears we are having SQL issues. See below - any ideas? 

 

Good morning - 

 

We are using ACT! 2008 Premium for Workgroups Version 10.03.182, Hotfix . 

 

When attempting to remove inactive/active users from a database we receive an error message after we receive the prompt to remove the contact from the database - when choosing either option (Yes or No) we receive the following: 

 

The INSERT statement conflicted with the FOREIGN KEY constraint "USER_COLUMNACCESS_USERID_Fk". The conflict occurred in database "GoLead", table "dbo.TBL_USER", column 'USERID'. The statement has been terminated. 

 

We have also had many problems regarding speed. Our database has over 117,000 records in it and we were told that eliminating inactive users may help this problem. Any help would be greatly appreciated! I searched the knowledge base and couldn't find anything.

 

Traci Whetzel

Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Speed Issues ACT! 2010?

This sounds like a database corruption as per this ACT! Knowledge Base article -

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1987...

 

Don't use the link there for Export/Import ... it's for the wrong ACT! version.

 

Backup first!

 

Then try repair with ALL options as per:

http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1964...

 

If that doesn't help, I'd contact database services to see if they can repair it

New Member
Posts: 4
Country: USA

Re: Speed Issues ACT! 2010?

Thank you!