Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Technical
    • Sage 100 New Features ( Brief )
  • Sage 100 Support

10 Ways To Speed Up Sage 100

December 15, 2015 by Wayne Schulz

speeding_ticket

How Can I Speed Up Sage 100? What Causes Slowdowns?

One of the top questions  we receive about Sage 100 centers on speed. Typically, how to improve slow network performance on a Sage 100 system. Often the questions center around the amount of time  it takes to start Sage 100, the time it takes to  print forms or reports or the time that a posting routine will take to complete.

In most cases the speed of Sage 100 can be drastically improved simply by following a few easy tips. These are things that you can probably do yourself to get your system back in fighting shape.

Top 10 Tips To Improve Sage 100 Speed

 

  1. Check your anti-virus – Test your anti-virus settings by excluding all the files in your \MAS90 folder. Do this on both the server and workstation. During testing exclude ..\MAS90\Pvxwin32.exe and ..\MAS90\Launch32.exe as well as files with the extensions: DCL, DD, DDE, DDF, LIB, M4L, M4P, M4T, PRM, PVC, PVX, RPT, SOA. Once you narrow the problem down to a specific area, gradually increase the level of anti-virus scanning. Never run your system with anti-virus turned completely off.
  2. Check your malware scanning – Aggressive malware scanners – on both workstation and file server can be the source of slowness. Begin the diagnosis by excluding your \MAS90 folder from scanning.  As with anti-virus, you should not completely de-activate malware scanning. Once you determine the cause, be sure you gradually reactivate malware scanners.
  3. Trim data files – Large data files can slow the posting process. How large is large? Typically at sizes over 2  GB we hear from customers with slow speed concerns. Set data retention options in the setup menu of each module so that files are automatically purged at month and year end.
  4. Use Remote Desktop – If your office is home to a large number of Windows XP (ie – underpowered) computers and an upgrade is not on the horizon, think about using Remote Desktop to virtualize those workstations.  With Remote Desktop Connection, you can sit at a PC and connect to another PC in a different location (the remote PC). For example, you can sit at your home PC and connect to your work PC, and use all of your apps, files, and network resources as if you were sitting right in front of your work PC.
  5. Get Sage 100 Advanced or Premium – An upgrade from Sage 100 Standard to either Advanced or Premium is almost always guaranteed to boost speed. Don’t upgrade before ruling out the other sources of slow speed mentioned in this list. Those who upgrade are seldom disappointed in the additional performance boost. This upgrade seems to give the most noticeable speed boost to users with 15 or more simultaneous (concurrent) users within Sage 100.
  6. Use sub-reports – Crystal Reports which use complicated table linking can bog down like a car stuck in 4 feet of mud. One tried and true way to work around this is with the use of sub-reports inside of Crystal. They are not complex to create and the speed boost can be amazing. Additionally, if you’re using Sage 100 Advanced use the C/S (client server) ODBC driver.
  7. Double check links in your forms or reports – A good rule of thumb when designing Crystal Reports is to use the least number of table links possible. Often Crystal Reports will use a table wizard to create automatic joins (links) between different tables. Sometimes it is good at guessing at the links needed. Other times it will create many more table links than required – which can slow your reporting to a crawl. It’s worth taking a look at your table links on any Crystal Report which is running slowly.
  8. Upgrade servers – More memory. Faster hard drives. This may be the best way to boost performance and is especially advisable if you’re running other applications on the server or have over 15 users of Sage 100. One user on Sage City recommends Lan Speed Test (Lite) which measures the speed of your network connection.
  9. Upgrade workstations – Upgrading to the latest operating system with 8 GB or more of memory can help improve almost any application performance.
  10. Mirror data tables to SQL – One trick of the trade which can save lots of time over upgrading or purchasing new hardware is a software add-on called “SQL Mirroring”. This program constantly replicates your Sage native tables into a SQL database. From this SQL database you can generate forms and reports at significantly faster speeds.

 

Demonstration: DSD SQL Mirroring

 

 

 

Before Contacting Support: Use This Form To Gather Information On Your System

Sage 100 Speed and Performance Template from Schulz Consulting

 

 

 

[gravityform id=”1″ title=”true” description=”true”]

Share this:

  • Share on X (Opens in new window) X
  • Share on Facebook (Opens in new window) Facebook
  • Email a link to a friend (Opens in new window) Email
  • Share on LinkedIn (Opens in new window) LinkedIn

Filed Under: Sage 100 ERP Tagged With: sage 100, speed

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage-certified consultant based in Connecticut. He has worked with Sage 100 since 1986 and provides remote consulting to companies throughout the United States. He is a founding member of the 90 Minds Consulting Group. To discuss working with Schulz Consulting, start with the Sage 100 inquiry page. Information is reviewed before follow-up about fit and next steps; technical work is scoped and priced separately.

Sage 100 Newsletter

Search Our Site

Sage 100 News

  • How to Fix: Sage 100 Desktop Launcher Closes Immediately After Login (No Error)
  • How To Update Sage Intelligence Keys as Sage Moves Away From Unlimited Licenses
  • Get More From Your Sage 100 Partnership
  • Sage Future 2025 Preliminary Agenda Released
  • Upgrading Sage 100 to 64-bit: Avoid These Integration Pitfalls
  • What’s New in Sage 100 2024? ( Video )
  • Sage 100 Users: Conquer Minnesota’s New Sales Tax & Delivery Fee Headache-Free
  • Elevate Your Sage 100 Expertise with SchulzSays: The Ultimate Newsletter for Users and Consultants
  • How To Purge Cleared Bank Reconciliation Transactions in Sage 100
  • 10 Exciting New Features in Sage 100 2024

Contact Us

Schulz Consulting · Connecticut Office · Available remotely nationwide.

Contact Schulz ConsultingPhone: 860-657-8544Email Us

We are a local branch of DSD Business Systems Connecticut.

Copyright © 2026 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

sage 100 email newsletter

Schulz Says Email Newsletter

Sent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.

Loading Comments...

You must be logged in to post a comment.