I've had as many as 10 simultaneous users on a Foxpro system with no loss of performance. I think it depends on the application. My collection agency software requires hardly any processing power. I suspect we could have 100 simultaneous users.
************************************************************************ --- On Thu, 9/4/08, KAM.covad <[EMAIL PROTECTED]> wrote: > From: KAM.covad <[EMAIL PROTECTED]> > Subject: Re: Speed issues - multiuser application > To: "ProFox Email List" <[email protected]> > Date: Thursday, September 4, 2008, 11:23 PM > All the responses are good. You will always get better > performance with one user, that is a given. But I have > installations with as > many as 80 simultaneous users with VFP9 SP1. Actually over > 250 but I don't think more than 80-90 ever connect at > the same time, > probably only 20-30 active, even heavy data entry users. > Many users require a dedicated server with a lot of memory. > When you get > more than 10, you need to consider using terminal services > on dedicated servers which access the data on a separate > dedicated > server. If you play with it, you can make a system with as > good performance as you see on those 'very large > distributed > applications' out there. At some point you have to > realize that too many simultaneous users, too much > simultaneous data transfer > will force you into a different database solution. Be sure > that your user interface uses only views, no direct table > updates. > Reports with direct table updates will kill the > performance, even with 2 users on the most powerful > hardware. Fox hogs all the > memory it can get. That is how it performs. It can work for > you or against you depending on your design. > > > > ----- Original Message ----- > From: "MB Software Solutions General Account" > <[EMAIL PROTECTED]> > To: "ProFox Email List" <[email protected]> > Sent: Thursday, September 04, 2008 6:17 PM > Subject: Re: Speed issues - multiuser application > > > Gil Hale wrote: > > <snipped> > > > > All that said, the difference in performance on the > P75 machines was > > noticeable in terms of a few seconds (like 3 seconds > instead of 1 second for > > some processes). I never saw multi-user access result > in a > > seconds-become-minutes impact. You aren't running > under Vista are you <g>. > > How punchy is the File Server (CPU, RAM, LAN i/o > speed). Are you running on > > a switched LAN connection, or a hub? Are you sharing > that switch/hub with a > > data intense device (Exchange Server)? How big are > the tables in terms of > > records? Are you doing direct table hits, or using > parameterized (and > > optimized) views? > > > > Piggybacking on Gil's comments---grab data only when > you need it. Avoid > senseless queries pulling data over the wire that you > don't need. > > [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.
