Sage 100

I have a client that runs the full 4 step item balancing sequence every month. Their volume of transactions warrants it. 

However, years ago we moved them from Adv to Prem & ever since then, it runs sooooo slow. Everything else sped up for them, like navigation, posting, reporting, etc.  But not the *UTL > Balance Inventory Quantity and Cost, the Recalculate Item History, closing of module periods, & rebuild sort files. Utilities are just slow now. 

Company B - secondary company with not a large transaction volume.

The Balance Inventory Quantity and Cost started 10:20pm & the Recalc Item History finished at 1:18am. 3 hours for these 2 utilities.  (I ran this for another company last night on Advanced with more transactions & much longer history & it took maybe 5-10 minutes total)

Company A - main company with high volume.

The Balance Inventory Quantity and Cost started 11:34pm & the Recalc Item History was still running this morning. 

Its just getting out of hand. What can be done to improve this performance? Has anyone else noticed these work worse in Premium? Does anyone else have these kind of lengths of time? I would think if I purge some history it will help, but I know the first time I ran it in Premium it was much slower, so its not like it just progressively got worse over time. 

Thoughts? Suggestions?

------------------------------
Dana Young
Lehman Wesley & Associates
------------------------------

I recall a conversation during a 90M conference 10 years ago that SQL was actually SLOWER transactionally than ADV but the Crystal reporting was blazingly fast.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

The problem with Premium is that Sage uses the same RBAR (row by agonizing row) code exactly as in ProvideX flat files, even when SQL has much better ways of doing the same thing with sets.

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
------------------------------