Well I use direct table access and since Windows 98, we've never has any corruption. It seems all corruption in the past has all been related to hardware.
--- On Fri, 9/5/08, Charlie Coleman <[EMAIL PROTECTED]> wrote: > From: Charlie Coleman <[EMAIL PROTECTED]> > Subject: Re: Speed issues - multiuser application > To: "ProFox Email List" <[email protected]> > Date: Friday, September 5, 2008, 1:08 PM > 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. > > -Charlie > > > > _______________________________________________ > 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. _______________________________________________ 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.
