Clarion/Network speed

Advertisement


Question
We recently upgraded our network, new server running Windows 7 Professional.  We also upgraded all wiring to Cat 6, highspeed 24 port switch, upgraded all ethernet cards.  We have about 8 workstations all running XP.  Our software was written in Clarion 5.  My problem is running a process on a workstation vs. directly on the server.  These processes generally loop though our database which resides on the server, about 50,000 records, and adds up daily sales or inventory.  We have several different processes but they all work pretty much the same way.

Here's my problem, when running the process on a workstation it can take 3-6 minutes to complete.  Running the same process on the same data directly on the server takes only 3-4 seconds.  I realize that the workstations will be somewhat slower, but this is unacceptable.  I have had two local computer gurus look at this but have not come up with an answer.

Any suggestions?

Thanks in advance,
Fred

Answer
Keep in mind that when data is sorted on the server and you're running the program from the workstation each record read has to be transferred to the workstation and if changes made the results transferred back. That will dramatically slow. To get the best possible performance without rewriting the app, make sure your machines all have gigabit network cards and you have a gigabit switch.

Drew

Clarion

All Answers


Ask Experts

Volunteer


Drew Bourrut

Expertise

As Clarion programmer since version 2.0 for DOS (1988), I am a consultant who specializes in Clarion programming. I have converted systems from DOS to Windows and have worked with every version of Clarion for Windows. My background has also included teaching database design, SQL programming, project management, and programming in a variety of languages from COBOL to PL/I. I have been a consultant since 1974 and a programmer since 1966.

Experience

Clarion allows me to write for a number of unrelated businesses. I've written applications that are accessible only via the web as well as communications applications and also large (more than 270 procedures) applications for service-oriented businesses.

©2016 About.com. All rights reserved.