Mike, I've got MySQL handling about 1/2 of the data load for my POS app and it has been like "lifting a huge load off my shoulder." Extremely reliable and very responsive. There's been a little learning curve due to the differences between the data types used by VFP and MySQL, but once you get over that, clear sailing. Also, it's great once you have your SQL Communications routines written, to just plug them into any new app and then call the MySQL communications functions just like they were Foxpro functions.
I just wish I had all my apps rewritten to move them off DBFs and I wouldn't have to hassle with them anymore. I would say that moving from a DBF mentality to a data-server back-end is one of the top three paradigm shifts in the VFP universe. Maybe even the top two. (I think the change to a browser-based interface is #1, but then are you still really producing VFP apps?) ------------------------------- Yes. I've built a framework from which I can generate multiple products, but resources being what they are, I have just 1 in production. 3 more in the wings. I'm decided on a dual-capability to give myself and at some point customers a choice between local/lan tables and MySQL that is hosted (and supported) on the net (that is, I'm not going to support - and be responsible for - customer local MySQL software installations). Today all customers are using tables. I've heard the stories, and to a much lesser extent experienced, problems with corrupted tables. It's my experience that table buffering, well tested code and improved hardware and software in general make such problems much rarer then times past. The product fixes index problems automatically. It's been a long time since I've had data corruption problems here or reported to me. The thought of getting to use MySQL without building a dependency is comforting to me. Looking ahead, when $ permits I would like to setup an IBM server with z/VM http://www.redbooks.ibm.com/abstracts/sg247316.html it can run z/OS http://www.redbooks.ibm.com/abstracts/sg246366.html?Open , Linux, Windows http://esj.com/articles/2011/05/24/ibm-windows-on-mainframe.aspx , z/TPF http://www.ibmsystemsmag.com/mainframe/administrator/performance/z-TPF_intro duction/?page=2 , etc. This provides what's available today plus some, not the least of which is a real batch processing capability. It's amazing how the Windows world lived without this for so long. Bill _______________________________________________ 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.
