RE: Any real speed advantage with dual Xeon processors?
From: Lee Mitchell (Leemi_at_online.microsoft.com)
Date: 08/03/04
- Next message: Holger Vorberg: "Re: Grids on form with Private Datasession and 3 tier application"
- Previous message: Edgar Ortiz: "Re: FPW2.6a changing browse title"
- In reply to: turiya36: "RE: Any real speed advantage with dual Xeon processors?"
- Next in thread: Rick Bean: "Re: Any real speed advantage with dual Xeon processors?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 03 Aug 2004 14:13:33 GMT
Hi Neil:
You have a good answer on the hardware, so I will address some software
ideas to improve performance.
1. Make sure VFP is optimized to use memory when handling data. Use the
SYS(3050) function for this task. See 176483 PRB: Large Amounts of RAM
Seem to Process Data Slowly
http://support.microsoft.com/?id=176483
2. Make sure your temp files are directed to a local folder on each
workstations hard drive. Use the Tmpfiles= command in the Config.fpw file.
3. Ensure all SELECT-SQL commands are optimized using the SYS(3054)
function. See
248608 INFO: SQL SELECT Optimization Levels and Performance
http://support.microsoft.com/?id=248608
156551 How To Use SYS(3054) to Optimize a Query
http://support.microsoft.com/?id=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 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
>Ni Neil
>I run my networked app on a dual Xeon file server - and yes, it makes a
huge difference in >speed. My suggestion to you is put in as much RAM as
you can possibly afford. In fact, unless >>each of your users workstations
will also have 1000BaseTX, I would recommend more RAM >before the network
card. Some very, very lengthy processes were 5 - 6 times faster after
going >from 1GB to 2GB of RAM - it made a huge difference in performance.
An example was packing >and reindexing 14GB of tables.
>Most of the processes that take a long time were run using local drive
access via terminal server >on Windows 2000 / 2003 server. I recommend
this approach as well over accessing your tables >from the network.
"Neil Waterworth" wrote:
> Hi,
>
> I'm looking for the fastest performance I can get on a networked VFP app.
> The server which holds the data is currently dual Xeon, lots of RAM, Win
> 2003 Server, 15K SCSI drives, 10/100BaseTX LAN. My current idea is to
> upgrade the server to 1000BaseTX, and buy a dual Xeon workstation, plenty
of
> RAM, 1000BaseTX, 15K SCSI drives and XP Pro. The app only needs to work on
> the one workstation, and the server is simultaneously handling data for
50+
> other workstations with lower performance requirements. The data is all
free
> table - I can't use DBCs/stored procedures because of FPD apps sharing the
> data. Do the dual processors make a difference to workstation speed with
> VFP? Does anyone have any better ideas? VFP7, but going VFP9 as soon as
it's
> available.
>
> Regards,
> Neil
>
- Next message: Holger Vorberg: "Re: Grids on form with Private Datasession and 3 tier application"
- Previous message: Edgar Ortiz: "Re: FPW2.6a changing browse title"
- In reply to: turiya36: "RE: Any real speed advantage with dual Xeon processors?"
- Next in thread: Rick Bean: "Re: Any real speed advantage with dual Xeon processors?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
