On 28/12/2013 11:00, MB Software Solutions General Account wrote:
On Fri, December 27, 2013 12:42 pm, AndyHC wrote:
A multi-user dbf based VFP app does /not/ work very well over a [local]
network. The upgrade path I used (and would recommend) if first go to
remote views, then migrate to a dbms backend. With the app (and,
optionally, dbc) on the users' machines (downloading the app is SLOW -
reserve that for updates) and the data on the server you should have no
problem moving the server to a remote location/ the Cloud (though I've
never done Cloud computing). Let's face it, dbf's were really designed for
single users, sharing can be flakey, and downloading entire dbf's over a
network is a no-no.
I disagree with that position. I've had multi-user apps with maybe 25-50
users using VFP DBC/DBF with local views and it worked great. I'd love to
see what was causing your experience to be contrary to mine. A/V software
perhaps getting in the way?
OK I skimped on my comment, I agree that local views (and designing your
app to minimise network traffic) can help a lot. I was really talking
about old style foxpro 'USEing' dbf's. Using/ changing to local views
also makes it /comparativ//ely/ easy to move to remote views later
(though null values, varchars and a few other things are waiting to bite
your ass!).
My own rule of thumb was to consider going to dbms when user numbers
grew to around 30 (or 10 who complained about slow speeds!)
<snip>
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.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.
