Community
Showing results for 
Search instead for 
Do you mean 
Reply

Factors affecting performance for remote connections

Astute Commentator
Posts: 14
Country: United States

Factors affecting performance for remote connections

Hello All,

 

I have an ACT database being accessed by a person in another city.  The performance is bad. I believe that it is because we have a DSL line in the host office.  We have a download speed of about 2.5 Mbps and an upload speed of about 0.35 Mbps. Now I have an offer to upgrade to a connection with 4Mbps in each direction.  Does anyone have any experience to support my theory that a faster upload speed (from host to client) will pretty much eradicate the problem?

 

Thanks for your time.

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Factors affecting performance for remote connections

It would have to improve performance. The ACT! program demands significant communication between the database on the SQL servver and the local program. That's the reason that higer speed in RPM hard drives improve performance.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Astute Commentator
Posts: 14
Country: United States

Re: Factors affecting performance for remote connections

Thank you for your reply, Roy.

 

I am a little surprised by your comment about the rotational speed of the hard drives.  Can you quantify the effect of 7200 vs 5400?

 

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Factors affecting performance for remote connections

Significant! In my experience with both perhaps 20 to 30 percent.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Factors affecting performance for remote connections

Most consultants would consider 7200 rpm as bare minimum for decent performance.

Other ways to improve performance for the remote user might be to look at synchronisation, desktop sharing or web
http://blog.glcomputing.com.au/2009/11/supporting-remote-users-with-act-by.html
Copper Contributor
Posts: 66
Country: USA

Re: Factors affecting performance for remote connections

After trying many different things to get remote users working with ACT (including synching and Web access) we found that the most efficient solution for the remote user is just to remote desktop to a computer or virtual machine in house and work in the database from there.