Very large GL batches - posting performance

Question

Does anyone know any smart ways to potentially improve GL batch posting performance? We are looking at typical batches of 1500 to 2000 entries with 8 details per entry. They take 7 minutes to post on a fairly high end server. 
 I'm wondering if there are is any tuning anyone knows about that helps specifically with Sage 300 posting. Also if anyone has experienced whether more smaller batches post quicker overall, or fewer but bigger batches. 
 They are looking at 20 days to post December batches so any percentage reduction would make a big difference. 
 Thanks all.

Stephen Bagnall · Answer

Hi. In the end we couldn't improve performance significantly. It's mostly tied up in the Sage 300 business logic so any tweaking of SQL and other configuration didn't help much. The only possible significant improvements might be posting settings in Sage 300. For example, when day end processing is run, whether posting of AR takes place immediately, etc.

Shane - Ascend Business Solutions · Answer

Potential bottleneck would likely be the typical: 
 Antivirus (server / client) 
 Network latency 
 SQL tuning (are you running a maintenance plan to apply statistics and rebuild indexes?) 
 Server ram

Other consideration might be to have the SQL data and log file on separate hard drives and optimization or usage of raid configuration to improve data write speed. 
 
 Lastly, a SQL profiler may show slow queries and lead to improvements by adding indexes.

Sage 300

Very large GL batches - posting performance

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING