FoxPro database connector - VFP Application search very slow

Author

VFP Application search very slow

ITJACKIE

2005-04-11, 7:26 am

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

2005-04-11, 7:26 am

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

"ITJACKIE" <it_jackie@hotmail.com> wrote in message
news:%23SkImlmPFHA.2356@TK2MSFTNGP14.phx.gbl...
> 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

2005-04-11, 7:26 am

> - 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

2005-04-14, 9:24 am

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

"Olaf Doschke" < T2xhZi5Eb3NjaGtlQFNl
dG1pY3MuZGU@strconv.14> wrote in message
news:uytl6MpPFHA.2520@tk2msftngp13.phx.gbl...
>
> 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

2005-04-14, 1:24 pm

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

"Juan Alonso" <jacinc2@hotmail.com> wrote in message
news:etK1AjPQFHA.1096@tk2msftngp13.phx.gbl...
>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
>
>
> "Olaf Doschke" < T2xhZi5Eb3NjaGtlQFNl
dG1pY3MuZGU@strconv.14> wrote in
> message news:uytl6MpPFHA.2520@tk2msftngp13.phx.gbl...
>
>

Sponsored Links