On Thu, September 4, 2008 11:23 pm, KAM.covad wrote: > 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.
I came across older code of mine recently where I had a local cursor (not an updatable view, but perhaps a read-only view if it was even a view) and I had logic in my save that basically did a SCAN of the cursor, then did a SEEK into the table for which it represented and did the appropriate action (insert/update/delete) based on the getfldstate of the record. Using the SEEK on the PKs, I'm pretty sure it was robust enough to handle some big dogs, but admittedly, the app was only in use by a very small number of users. _______________________________________________ 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.
