...and can I add to that list decent properly set up servers.... a must. People still trying to work on a Windows 7 machine as a server with multiple clients are asking for trouble... but I still know some who think it is fine.
Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Dave Crozier Sent: 07 May 2015 09:08 To: ProFox Email List Subject: RE: Delay in USEing table on network causes errors, using VMs, Win7 +1 for Alan's comments. The only reason we have migrated over to M$ SQL is the data size restrictions in VFP. With a good network infrastructure/cabling then VFP DBC's * DBF's cause little if no problems. When we had cheap hardware (clone PC's) and 10Mb cabling then we used to get errors/timeouts etc. but since we moved over to good HP kit with Gigabit as standard (100Gb shortly) we have not experienced corruption on any of the native VFP systems we still have in place here. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Alan Bourke Sent: 07 May 2015 08:53 To: [email protected]; [email protected] Subject: Re: Delay in USEing table on network causes errors, using VMs, Win7 > If you are going to use network shares for the tables, just be care > with the combination of client OS and server OS, because any > combination starting with Win7->Win7 or higher, will cause corruption > problems. Sorry but that's just not true in the general case. We have hundreds of sites where this is NOT the case. It's true that sometimes problems occur like the CDX corruption issue with SMB2 that cropped up in the early days of Windows 7, normally these can be worked around and are later hot-fixed out by Microsoft. I have found that the Windows 7 and Windows 8 combination with Server 2012 is extremely reliable in terms of DBF files. > why everytime more people is staying away from DBFs and migrate to a > client-server database (MySql, MariaDB, Oracle, SqlServer, etc) Having said the above, in general it is indeed IMO a good idea these days to use a dedicated database server like those you mention, but I would do it for reasons of scalability, security, ease of backup and so on. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] _______________________________________________ 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.
