Back in the days of VFP3 I had noticed the tables on a multi-user solution were noticeable snappier when a single user was accessing them for read or write purposes, as opposed to when additional users were accessing the tables. I did not notice any appreciable difference between 2 and > 2 usrs, all the way up to about 65 users, however. It is as though once a table sees it is opened by > 1 user it gets into "multi-user management mode". Those were machine that had P75 CPU with 32Mg RAM (!). As machines got faster, and with VFP7+ available, I did not notice that behavior as much. But I have no reason to believe there is not some kind of overhead multi-user management hit with performance.
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? Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Michael Savage > Sent: Thursday, September 04, 2008 5:17 PM > To: [EMAIL PROTECTED] > Subject: Speed issues - multiuser application > > > I have a main screen that works great when single user, but the minute a > second user opens the same screen, it slows down.. i.e. from seconds to > minutes to open. > > VFP 9 application. Will send more details tomorrow. I am writing > this up as > I leave. Gigsbit network. > > Just looking for some ideas about increasing performance on a network. > > Thanks, > Mike > > > [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.
