Accpac Performance

[erprider]

Hi Guys

I've implement the Sage Accpac 5.4A and i done the workstation setup but it is pathetic whil opening the accpac screen from the client PC its very slow
any idea how to fix it? or how to improve the accpac performance?

Sage Accpac ERP 100
SQL 2005 Version
including all latest service pack in ACCPAC modules

 

[Jay Converse]

Network configuration?
Server specs?
Workstation specs?
Virus checker used?

 

[ettienne]

SQL 2005 native client installed?

 

[erprider]

Thanks guys for the reply,Well network configuration is window 2003 server with 2GB,
virus check is using,workstation computer has 1 GB RAM ,
Native is not installed.

Basically let me know that how to improve the ACCPAC performances?

 

[erprider]

Thanks guys for the reply,Well network configuration is window 2003 server with 2GB,
virus check is using,workstation computer has 1 GB RAM ,
Native is not installed.

Basically let me know that how to improve the ACCPAC performances?

 

[Jay Converse]

1. Which virus checker? In any case, disable checking of the Accpac Programs folder.

2. Install the native client.

3. Network config: NIC and switch speeds?

 

[ettienne]

2GB on a Windows 2003 server is minimal nowadays, we normally recommend at least 4GB, especially when running SQL server as well.

 

[erprider]

Do i need to install the native client in the client PC?
Does it make better performance?

 

[ettienne]

SQL native client is installed on the client PC (but not on Vista because it is already installed). Yes it gives better performance.

 

[erprider]

Thanks you very much guys let me installed the native client and check it, More over Is there anythingelse? to make a better performance

 

[Jay Converse]

You still haven't answered all our questions.

 

[DjangMan]

Related to performance: Are the screens slow to load but once opened the data is retrieved at a resonable speed? If that's the case you need to follow the advice above and get your anti-virus software to leave Accpac alone. Each Accpac screen is an ActiveX control and ActiveX controls are often scrutinized by anti-virus software very carefully causing long delays in opening the screens.

And then answer the rest of the questions.

 

[erprider]

1. Which virus checker? In any case, disable checking of the Accpac Programs folder.

Yes,Kaspersky virus check

2. Install the native client.
No

3. Network config: NIC and switch speeds?
24.0MBPS

Workstation specs?
2GB Machine Windows XP.

for DjangMan (Programmer) question:

Yes indeed, Accpac Screen loads itself very slow and the data retreive speed also very low.

 

[Jay Converse]

24 Mbps? That's your problem. Absolute minimum is 100. No wireless. 1000 is better.