Accpac slow when posting invoices

[MTPS2008]

Hi,

We are using Accpac ERP-500 (5.3) running under P-SQL (Ver.9) on a Windows 2000 Server (SP4).
Remote offices are connecting via Terminal Services over VPN.
Terminal Server (also W2k Server) and Database are on two different machines.
Until recent everything seemed to be ok, even though we were always having little problems, mostly connectivity issues (disconnected sessions). However, what I noticed today is when posting a new invoice in Order Entry with about 40 line entries, it takes about 2 minutes to process. Is that normal for Accpac? Maybe due to growth we never experienced this issue before, but are there any monitoring tools that help me understand why this huge delay if not by Accpac design?

 

[Jay Converse]

Run a Pervasive Rebuild on the OE tables.

 

[ettienne]

Is the slow down on both the local computers and the terminal server, or just the terminal server? Or are they the same?

 

[MTPS2008]

It happens actually on both, running Accpac locally and through terminal services with identical delays.

 

[MTPS2008]

I have never used the rebuild function in pervasive. Is it save to do, or does it have an impact on the database structure/tables? I assume it should be done after hours when nobody is on the system.

 

[Jay Converse]

It's totally safe, and it does nothing to structures. All it does is dump out and freshly reload the tables to rebuild the indexes. The files can't be in use while it's running. If there are any problems with the rebuild, it skips the file and moves to the next one.