Solved

Act! Database Slow - Moved from 2000 to v8

Posted on 2006-11-08
1
263 Views
Last Modified: 2013-11-24
Hi all,

Got a client who was using Act 2000. 11 Users, about 28000 contacts. All running from HP Server (1Gb RAM, Pentium 4, 80Gb IDE Drive, MS Small Business Server 2003) - no problems.

Now, one of the users boyfriends suggested they move to Act version 8 cause it was so much faster and better and he would support it and so forth. Well, its installed, the boyfriend is no longer dating the consultant, the database is horribly SLOW and it now my problem. (sheesh what people will do for a bit of legover...)

Seriously though: Database is now running using the SQL Engine as part of the SBS. The repsonse time on the client pcs is pathetic to say the least. How/where do i start. I've upgraded the RAM in server to 2Gb. The database is running off it own drive. Any more i can do or suggest?

Thanks
Sean
0
Comment
Question by:SeanNij
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
SStroz earned 500 total points
ID: 17909972
Sean,

That's a weird turn of events.  You will be limited in what you can do for them.  ACT! 2006 is much better but utilizes new technologies so old equipment doesn't handle it that well.  ACT! 2000 uses an older architecture and will be much quicker (although limited in functionality) on newer systems.

A few things:
Make sure they're using the most current version 8.0.2 hotfix 5.  (ACT! 2006 is the marketing name)
Upgrade equipment wherever possible.  Shoot for fast processors, 1 MB RAM, and hard drive speeds at least 5400 RPM.

A seperate server would be great.  SBS really uses a lot of RAM for the other processes.  Ideal is a stand alone server for ACT! with 2 GB RAM, good processor, RAID, etc.

Remind the client that SQL scales and is more stable than their old version of ACT! and they have more functionality like Company Records, Opportunity List, Record Security, Export to Excel features, etc.  If they can get past the performance issues they should be able to make more money with this version of ACT!

Good luck

Steve





0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question