|| Agreed. VFP databases are awesome for local/LAN stuff, but you open up so many more opportunities by using a database like MySQL (or similar).||
which while true doesn't help me with a client that has a good land-based app using VFP tables and now wants to use it across an interstate WAN. A rewrite using SQL Server or the like has been mooted many times but wont get agreed to. Is GraphOn as good as people say it is? -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Thursday, 18 March 2010 9:23 AM To: ProFox Email List Subject: Re: Can traditional VFP9 (with VFP9 database on backend) apps work over VPN? Paul McNett wrote: > On 3/17/10 2:38 PM, geoff wrote: >> Ive done this a couple times before, but as others have said, it is truly >> murderously slow. And in many cases so slow as to be useless. And then add a >> second user and suddenly it is almost unworkable with data corruption and >> other disasters. Quite simply, don't do it. > > Up until a couple messages ago, I was under the impression that he wanted to put a > VFP database on the other side of the VPN, which would perform horribly as you say. > But apparently it is a MySQL database, which can work reasonably well, even multi-user. No no no...you were right the first time. I said if I was to re-do it, I'd definitely use the MySQL database backend as I've done for the guy's last few apps. > I was doing this back in VFP6,7,8 and MySQL 3.51 and 4.x, in 2002-2005 or so, using > SPT connections and making the cursors updatable with tableupdate(). Indeed, one of > the major reasons for moving away from VFP tables to MySQL was for good remote > performance. Which is why I still swear by it. > > Along with good performance, it can be every bit as secure as banking online. What is "every bit secure as banking online" -- using MySQL? > > IMO nobody should be using VFP databases for data anymore, given the available robust > alternatives. Agreed. VFP databases are awesome for local/LAN stuff, but you open up so many more opportunities by using a database like MySQL (or similar). -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [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.
