Act! Database Slow - Moved from 2000 to v8
Posted on 2006-11-08
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?