>>SERVER : PIII500, 128MB RAM, 9.1GB HDD.
>>WORKSTATION : P133,16MB RAM, 2.1GB HDD.
>>
>
>The workstation is at about the bottom rung of what I'd use; I'd want to increase the memory, and given current prices, I'd probably retire the system entirely.

Can you suggest with our usage what type of configuration is best suited for us. We have around 20+ computers with about this configuration other 10+ are OK. If I had to change all 20 than the cost increases a lot. Another problem is we have almost all IBM computers, with above config, and we are not getting any support for those so that we can upgrade or exchange these computers. Since all other applications we are using is running very well on these computers, its a little difficult to convince our finance dept, to throw the current computers and buy new ones.

>
>You've omitted a number of major things that affect the performance of a LAN environment. OS - what's the server running, and what's the workstation running? What type of LAN (10BaseT, 100BaseT, etc.)? If the server is not run as a dedicated server, how heavily loaded is it?

We run Windows NT 4 SP5 as a dedicated File and Print server, with WIN95/98 clients. Some computers are having 10BaseT and others are having 100BaseT.

>
>>EXE size : 5MB, excluding BMP,ICO and Reports files (FR?)
>>
>
>The .EXE size is relatively unimportant; the fact that you put it on the server rather than on the local drive is IMO a bad choice; it forces you to load the .EXE over the LAN, nearly almost slower than local disk, and forces additional network traffic over the course of execution. If you have not set the temporary file location for the local system in CONFIG.FPW, it also may be forcing VFP to use the network rather than the local hard drive for temporary files, again hurt performance because of differences in relative speed of local disk vs things on the LAN, generating needless LAN traffic, and adding to the server burden,.

This software is just being developed and it is going through a lot of change over the period of time. If I install EXE an other files on all 35 computers, it will be highly cumbersome to keep on changing files on every computers even though for a small change in system. And FYI, We are using this system, in all our brach offices spreaded in 7 countries in Far East. So it will be very difficult for me to change the files in all the computers, seating my local office.

>
>>All files are stored on the server, and everybody is accessing the EXE from a shortcut created on their computer pointing to this exe file.
>>
>>The main problem is performance, sometimes the performance especially, for Loading FORMS, Running reports is extremly slow. can anybody please help me or point out what exactly could be done.
>>
>
>Read Chapter 4 of the VFP Installation Guide, which discusses configuring and optimizing VFP's performance.

I really appreciate your help in trying to solve my problems related to performance, please do advise me if any further fine tuning is required for faster access over the LAN.

Thanks &