Printing Reports taking abnormally long time since switching to workstations from Terminal Server.

Since moving my client from a Server 2008 Terminal Server to individual workstations, printing reports of any kind are now taking over 5-10 mins to print 5 pages.  This includes just running print preview.

I'm currently running Mas 100 ERP version 5.10.7.0 with 10 users now running Sage client on individual workstations.  Each workstation is Win 7 pro 64bit with 8GB ram. Printers are Dell Printers using an HP Driver mimic from the Terminal Server.

I have attempted to try printing to shared printer both from the Terminal Server and also a print server.  I have installed the printers locally as well with no luck.Logging into the MAS server and printing the reports still prints the jobs in 5-10 secs.  I have attached computers directly to the same switch that the server is on, but that does not help.  I have tried to get outside help from a Sage Support Company, but they were unable to help and just said they cant do anything with it.

Please let me know what I need to do to the client PCs to speed up printing in MAS!  Every other aspect, Office, web printing all print normally, just an issue in MAS

Thanks,

Keir

Parents Reply Children
  • 0 in reply to TomTarget
    Bandwidth throttling on the router :(
  • 0 in reply to 49153
    Thanks for the info.
  • 0 in reply to TomTarget
    Traffic does not go through router. This all happens on a gigabyte switch (running cat5e cables)
  • 0 in reply to Keir_B

    Did you check your network speed with the utility that 49153 suggested? I downloaded it and tried it on my system. If found that I was getting about 50MB throughput from my workstation to one server and about 80MB throughput to a different server. A different workstation was getting about 90MB. I have not tried it yet on any of my clients with noticeable slow operations (note that none of them are nearly as bad as your situation).

    The utility doesn't really tell you exactly what is wrong. It just tells you that something is slowing your throughput down and then you have to go hunting.

  • 0 in reply to TomTarget
    The Sage 100 system architecture matters, and while you said something about "the local odbc driver on the clients but also didn't help", but that is not the CS-ODBC configuration (which does not involve installing drivers on the client machines). Normally, with a Providex back end, the workstation's Crystal Reports print engine talks directly with the data files, over the network. These files can be large, and take time to open directly, line by line, linking table data... When configured, the CS-ODBC service (running on the server) does this for you. The client workstation doesn't access the Providex data files over the network, the service does that and returns the results to the client's print engine, which bypasses the heavy network traffic when printing.
    To set this up, look in the KB for details on configuring the CS-ODBC service. Then enable the option in User Maintenance for the people you want to test with.