VFP running slowly (URGENT)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ITJACKIE - 14 Oct 2004 03:48 GMT

Our company using VFP dev a appliaction for serval around 30staff use. I
using W2K server share VFP DATA and .exe diretory , user must map this
directory and run the .exe to login the system. Before user already VFP 8.0
runtime. Our server config 2x xeron CPU , 2GB RAM, 380 RAID 5. But i don't
know why i luanch appliaction 3 weeks, the program update and look up record
very slow, anyonw who advice me how to solve out the problems. is program
design or network isseus, please advice.

Jackie Wong

Reply to this Message

Stefan Wuebbe - 14 Oct 2004 09:47 GMT

A customVfp.exe residing on a shared LAN drive will always work
slower than a local one, sometimes even less reliable.

Aside from that, you might need to provide more details about which
particular code is slow exactly, more about data structure, index
expressions etc.
See also "Optimizing Your System" and related in help, a lot of details
involved. As far as "Rushmore" / Sys(3054) goes - for example with
this pseudo table
Create Cursor customer (lastname C(50))
Index On Lower(lastname) Tag lastname
this query would run slowly
Select * From customer Where Upper(lastname) = 'SMITH'
and this should be quick
Select * From customer Where Lower(lastname) = 'smith'

hth
-Stefan

> Our company using VFP dev a appliaction for serval around 30staff use. I
> using W2K server share VFP DATA and .exe diretory , user must map this
[quoted text clipped - 5 lines]
>
> Jackie Wong

Reply to this Message

Lee Mitchell - 14 Oct 2004 14:52 GMT

Hi Jackie:

Along with Stefan's suggestions, I would disable any anti virus or at least
make sure the AV is not scanning VFP data files:

304482 PRB: VFP Executable File Is Slow to Access Tables On Server
http://support.microsoft.com/?id=304482

321550 How To Optimize Visual FoxPro Applications While Using Norton
AntiVirus
http://support.microsoft.com/?id=321550

If this does not help, you need to locate the performance bottlenecks in
your code. I would run the exe inside of VFP with the Coverage Profiler
and get a log file to locate the slow sections of code.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;191953

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>A customVfp.exe residing on a shared LAN drive will always work
>slower than a local one, sometimes even less reliable.

>Aside from that, you might need to provide more details about which
>particular code is slow exactly, more about data structure, index
[quoted text clipped - 8 lines]
>and this should be quick
> Select * From customer Where Lower(lastname) = 'smith'

>hth
>-Stefan

>"ITJACKIE" <it_jackie@hotmail.com> schrieb im Newsbeitrag

news:eu8ZLiZsEHA.1336@tk2msftngp13.phx.gbl...

> Our company using VFP dev a appliaction for serval around 30staff use. I
> using W2K server share VFP DATA and .exe diretory , user must map this
[quoted text clipped - 5 lines]
>
> Jackie Wong

Reply to this Message