Charlie Coleman wrote: > At 09:23 AM 9/5/2008 -0400, MB Software Solutions General Account wrote: > >> 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 >>> > ... > > >> 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 >> > ... > > This sounds generally like what I use for my systems. Some of them have > probably 200 simultaneous users accessing them. No performance problems > (and folks say the system is snappier then the previous SQL DB Server system). > > There are also some sites that are set up to work with the systems over > VPN, with users in several different states (i.e. they're pulling the data > over the VPN connection). And they haven't complained about performance either. > > I never use Views because I can't see/control all the details of what is > going on under the hood. But I do agree that direct table access is not > advised. Even when editing a single record I use the SCATTER MEMO NAME ... > approach. Maybe this is why I've never had problems with VFP DB corruption > but others have <shrug> and it's certainly why I've never had the problems > with Views that others have had. >
I recall you using that approach. Actually, I probably patterned it after what you described when you spoke at CPVFUG so many years ago! _______________________________________________ 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.
