Aged Trial Balances in 5.5

[NeilN]

One of my clients has upgraded to 5.5 and is complaining about how slow the Aged Trial Balances (among other reports) is to run. I've checked in SQL Server 2005 box and the processor barely hits 10% and there's plenty of spare RAM for caching. Their ACCPAC integrator states, "...Aged Trial Balances have changed from CSV to temporary SQL tables so it is like comparing apples and oranges for those reports".

Running SQL Profiler I see that ACCPAC is sending thousands of queries to SQL Server when generating this report which accounts for the massive slowdown. Can we do something to address this issue? There's a 5 Megabit pipe between the client and SQL Server but even doubling the bandwidth won't help much if ACCPAC is sending that many queries.

 

[Jay Converse]

5 Megabit pipe? That's pitiful. Is it wireless?

 

[NeilN]

The SQL Server box is offsite. Users connect from the office via a dedicated VPN tunnel.

 

[Jay Converse]

Minimum speed for Accpac is 100 Mbps, as in a LAN.

 

[NeilN]

Thanks. I will see if we can move the ACCPAC client to a box in the datacenter.

 

[Jay Converse]

That's what your Accpac integrator should have told you, minimum network speed is old news.