Paul McNett wrote: > Jean Laeremans wrote: >> Oh forgot to mention took the time to find the most effective >> retrieval technique and found out that in general xbase commands were >> several factors faster than SQL. > > I don't think anyone is contesting this. xbase processes on a LAN really do fly. > > I'm with Stephen, though: there are many compelling reasons to move up to a C/S > architecture.
I haven't designed anything brand new with a VFP backend since about 2004, iirc. I've been using MySQL, and for many reasons, I love it (especially the ability to be disconnected for a time--avoiding the Error 1104s of the past with flakely networks using VFP backends on a LAN). FabMate still uses VFP9, and it still kicks ass, but I'd love to rewrite it with a MySQL backend for many reasons--disconnected advantage, running on server for intense processes (and this is perhaps where Steve was eluding), Web database ability, and probably more. But where he made his mistake which the others rammed him for was his comment that the entire table comes down across the network. Nope. In my time using VFP as a backend in designs that I've created, I'm thankful to say that I've never had any corruption. I know I've worked on others systems where there was corruption, and if it were to be redone, I would definitely take a different approach than some of the earlier designs, but all in all, I'd recommend using MySQL as the backend, given my success so far with it. I'd love to try out PostgreSQL and Firebird as well, and given my n-tier designs, I bet I could do so without much change in code. I just need to invent more time first....or get rid of all my debts so I had more ability to create free time. ;-) _______________________________________________ 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.
