I agree, 40 open files is no big deal. I have a VFP app that has been in ocmmercial sites since early 2001 that will have about 50, sometimes mroe, open files on the server, with up to 60 end user machines hitting it at one time, and there are no problems with "congestion". Some of these tables have over 1 million records, others are over 1gb in size. Some are open read-only at the client end of the connection, others are written to by the client side. The servers my clients use range from older P3 500mhz with 256mg RAM to P4 dual core CPUs running 1gb RAM. Nothing seems to bother The Fox when it comes to even that "much" activity.
That said, it seems to me if a server has 40 open files, accessed by a fairly large number of client PCs, and most of those open files are experiencing some real heavy activity (non-indexed locates, lots of read-write i/o, etc.) it could drag the server down a bit. But even with just 40 files that ain't no big deal, the larger issues would be write contention for one file being written to concurrently by multiple users without proper buffering/locking-unlocking use. Gil -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alan Bourke Sent: Friday, January 18, 2008 9:23 AM To: [EMAIL PROTECTED] Subject: Re: Win Server 2003 x VFP7.1 Eurico Chagas Filho wrote: > Hi > > I need some help here, please. > > 1. How can I communicate to my client that the 40 some open files he sees > are ok and are not clogging the network ? > 40 open files on a server? That's peanuts. And just having them open doesn't mean anything, least of all that all the data in them is being shovelled up and down the wire. They will be cached open by the server, is why there are so many. There are no particular issues with any flavour of VFP on Windows Server 2003 that I know of. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
