foxpro database on windows 2000 server really slow

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tim jifop - 17 Mar 2005 15:33 GMT

hi, we run several foxpro apps on our windows 2000 server (900mz twin cpu,
1.5gb ram), they used to run fine on an nt server (800mhz, 512mb ram) now
on the 2000 server the programs open fine but accessing the dbf files is
really slow.

does anyone have any idea what could be up?

Thanks in advance

Tim

Reply to this Message

Fred Taylor - 17 Mar 2005 16:13 GMT

Anti-virus software is a likely suspect. Make sure all the usual VFP file
extensions are excluded from being scanned, like .DBF, .FPT, .CDX, etc.

Signature

Fred
Microsoft Visual FoxPro MVP

> hi, we run several foxpro apps on our windows 2000 server (900mz twin cpu,
> 1.5gb ram), they used to run fine on an nt server (800mhz, 512mb ram) now
[quoted text clipped - 6 lines]
>
> Tim

Reply to this Message

Lee Mitchell - 17 Mar 2005 21:56 GMT

Hi Tim:

As Fred said, anti virus is probably the culprit here. See

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

You may also want to optimize your SELECT-SQL commands, implentment
SYS(3050) and use the Coverage Profiler to find any remaining performance
bottle necks.

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

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 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/
Purchase VFP8 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

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

>Anti-virus software is a likely suspect. Make sure all the usual VFP file
>extensions are excluded from being scanned, like .DBF, .FPT, .CDX, etc.

> hi, we run several foxpro apps on our windows 2000 server (900mz twin cpu,
> 1.5gb ram), they used to run fine on an nt server (800mhz, 512mb ram) now
[quoted text clipped - 6 lines]
>
> Tim

Reply to this Message

tim jifop - 18 Mar 2005 17:54 GMT

hmm, well i have disabled the AV to no avail still slow! its very odd really

we dont use sql commands just good ole fox

Reply to this Message