Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Act! Database Slow - Moved from 2000 to v8

Posted on 2006-11-08
1
Medium Priority
?
266 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 2000 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

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

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

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

722 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