FoxPro Setup - foxpro database on windows 2000 server really slow

Author

foxpro database on windows 2000 server really slow

tim jifop via DBMonster.com

2005-04-07, 8:05 pm

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

--
Message posted via http://www.dbmonster.com

Fred Taylor

2005-04-07, 8:05 pm

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.

--
Fred
Microsoft Visual FoxPro MVP

"tim jifop via DBMonster.com" <forum@DBMonster.com> wrote in message
news:9be38a3e40434a5
ea079ca929bde1212@DB
Monster.com...
> 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
>
> --
> Message posted via http://www.dbmonster.com

Lee Mitchell

2005-04-07, 8:05 pm

Hi Tim:

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

http://support.microsoft.com/defaul...KB;EN-US;304482
http://support.microsoft.com/defaul...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/defaul...KB;EN-US;176483
http://support.microsoft.com/defaul...KB;EN-US;191953
http://support.microsoft.com/defaul...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/i...cid=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.

>--
>Fred
>Microsoft Visual FoxPro MVP

>"tim jifop via DBMonster.com" <forum@DBMonster.com> wrote in message
> news:9be38a3e40434a5
ea079ca929bde1212@DB
Monster.com...
> 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
>
> --
> Message posted via http://www.dbmonster.com

tim jifop via DBMonster.com

2005-04-07, 8:05 pm

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

--
Message posted via http://www.dbmonster.com

Sponsored Links