VFP Application search very slow

[ITJACKIE]

Dear
Our company using VFP deveop a appliaction. This app with complied a exe
file an put the network share. User desktop with map this drive and drop the
.exe shortcut run the app. The problems with.
- When the VFP app run a 2-CPU / 2GB / RAID 5 HD for share 40 user acces the
.exe file , the speed very slow.
-When put tth app to another network server P-III / 256MB/ IDE HD for share
2 user access for testing., but the speed very fast.

- I want to know is the VFP .exe file is for share user, more user access
the .exe file with slow down VFP internal process.
- How can solve out this problems, please advice.


Thanks
Jackie Wong

[Eric den Doop]

What is your network speed? In what way is your app slow? Are you talking
about queries? You may have to optimize your queries and tables and indexes.
Read about "rushmore" in VFP help.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Post by ITJACKIE
Dear
Our company using VFP deveop a appliaction. This app with complied a exe
file an put the network share. User desktop with map this drive and drop the
.exe shortcut run the app. The problems with.
- When the VFP app run a 2-CPU / 2GB / RAID 5 HD for share 40 user acces the
.exe file , the speed very slow.
-When put tth app to another network server P-III / 256MB/ IDE HD for share
2 user access for testing., but the speed very fast.
- I want to know is the VFP .exe file is for share user, more user access
the .exe file with slow down VFP internal process.
- How can solve out this problems, please advice.
Thanks
Jackie Wong

[Olaf Doschke]

Post by ITJACKIE
- When the VFP app run a 2-CPU / 2GB / RAID 5 HD for share 40 user acces the
.exe file , the speed very slow.
-When put tth app to another network server P-III / 256MB/ IDE HD for share
2 user access for testing., but the speed very fast.

Is it the same clients using the same network, just
using a different fiel server?
Is there a different OS running on the P-III server than
the 2-CPU-server?

You're not the first one having that problem. Mostly
the server os reported was w2k so there seems to
be an issue related to that.

I'd recommend installing the exe on each client.

Bye, Olaf.

[Juan Alonso]

I have seen this before also. Although with what I have seen it is not the
W2K Server that has caused the problem. The problem has happened when you
have to share data ON A RAID. We had that same problem here. It is in the
RAID setting.

There are many problems with Raid HDs if you do not configure them
correctly.

I would say, before you do anything .. check your settings on the RAID.

I would also say, make sure you have a seperate CONFIG.FPW file for each of
your clients so that they DO NOT SHARE THE RESOURCE FILE that VFP/FP
creates.

Also you might want to make sure that your CONFIG.FPW file is configured
correctly also.

I can see that you are trying to run an app from your server. Well keep
this in mind. Part of your processes are local but part are not. There is
a big difference in testing TWO people and testing FORTY people on it.

Again, check your setting. I will tell you what, why don't you move to
CITRIX Servers and that way it is devided into say two server. I would
recomend DELL POWEREDGE SERVERS. They are very reliable, and flexible.

Anyway, make sure the RAID is configured for uptimum performance and that
you set the CONFIG.FPW for each of your users.

You can do this with one line in their Windows WorkStation. Set a variable
inside your system.

Windows 2000/ XP: Right Click "My Computer" and go down the context menu to
"Properties". Tab over to "Advance" and then look for a BUTTON that says
"Environment Variables"

Use the button to "Add" a new variable and create one called "FOXPROCFG=C:\
[ directory name of CONFIG.FPW ] + [ config.fpw ].

Now all you do is prepare a CONFIG.FPW file for each user according to their
use. Or you can just create one in the root of the EXE file and make sure
you specify drive letters and directory properly. If you use a directory
name that is not found on the local machine of the user there will be a
problem. I would go with the later and NOT put one in the directory of the
EXE. Your choice.


Anyway.. sorry for the load of info. I thought I would give you several
options to try.

Have a great day.

Johnny5

Post by Olaf Doschke

Post by ITJACKIE
- When the VFP app run a 2-CPU / 2GB / RAID 5 HD for share 40 user acces the
.exe file , the speed very slow.
-When put tth app to another network server P-III / 256MB/ IDE HD for share
2 user access for testing., but the speed very fast.

Is it the same clients using the same network, just
using a different fiel server?
Is there a different OS running on the P-III server than
the 2-CPU-server?
You're not the first one having that problem. Mostly
the server os reported was w2k so there seems to
be an issue related to that.
I'd recommend installing the exe on each client.
Bye, Olaf.

[Juan Alonso]

Oh shoot! I almost forgot.

Make sure you check your Server Settings as well.

You might want to OPTIMIZE your server for better performance as opposed to
better security.

I know that security is important, but sometimes Administrators add too much
un-necessary configurations to their servers
deeming them slow and dragish.

K .. done now... lol

Later,

Johnny5

Post by Juan Alonso
I have seen this before also. Although with what I have seen it is not the
W2K Server that has caused the problem. The problem has happened when you
have to share data ON A RAID. We had that same problem here. It is in the
RAID setting.
There are many problems with Raid HDs if you do not configure them
correctly.
I would say, before you do anything .. check your settings on the RAID.
I would also say, make sure you have a seperate CONFIG.FPW file for each
of your clients so that they DO NOT SHARE THE RESOURCE FILE that VFP/FP
creates.
Also you might want to make sure that your CONFIG.FPW file is configured
correctly also.
I can see that you are trying to run an app from your server. Well keep
this in mind. Part of your processes are local but part are not. There
is a big difference in testing TWO people and testing FORTY people on it.
Again, check your setting. I will tell you what, why don't you move to
CITRIX Servers and that way it is devided into say two server. I would
recomend DELL POWEREDGE SERVERS. They are very reliable, and flexible.
Anyway, make sure the RAID is configured for uptimum performance and that
you set the CONFIG.FPW for each of your users.
You can do this with one line in their Windows WorkStation. Set a
variable inside your system.
Windows 2000/ XP: Right Click "My Computer" and go down the context menu
to "Properties". Tab over to "Advance" and then look for a BUTTON that
says
"Environment Variables"
Use the button to "Add" a new variable and create one called
"FOXPROCFG=C:\ [ directory name of CONFIG.FPW ] + [ config.fpw ].
Now all you do is prepare a CONFIG.FPW file for each user according to
their use. Or you can just create one in the root of the EXE file and
make sure you specify drive letters and directory properly. If you use a
directory name that is not found on the local machine of the user there
will be a problem. I would go with the later and NOT put one in the
directory of the EXE. Your choice.
Anyway.. sorry for the load of info. I thought I would give you several
options to try.
Have a great day.
Johnny5

Post by Olaf Doschke

Post by ITJACKIE
- When the VFP app run a 2-CPU / 2GB / RAID 5 HD for share 40 user acces the
.exe file , the speed very slow.
-When put tth app to another network server P-III / 256MB/ IDE HD for share
2 user access for testing., but the speed very fast.

Is it the same clients using the same network, just
using a different fiel server?
Is there a different OS running on the P-III server than
the 2-CPU-server?
You're not the first one having that problem. Mostly
the server os reported was w2k so there seems to
be an issue related to that.
I'd recommend installing the exe on each client.
Bye, Olaf.