Transcription of Opportunistic Locking and Read Caching on …
{{id}} {{{paragraph}}}
Opportunistic Locking and read Caching on Microsoft Windows Networks A White Paper by Dennis Piccioni Revised: November 2016 Summary Most DataFlex applications today run on one of the leading SQL databases with Microsoft SQL Server being the most popular choice. SQL databases do not suffer from the OpLock risks or recent changes to the SMB protocols. Data Access Worldwide highly recommends that customers move DataFlex web, mobile and Windows desktop applications still using the file system "embedded database" to an SQL database as soon as possible to avoid the issues discussed below, and to enjoy better performance, reliability and scalability. Without special configuration, any file system database, including DataFlex's, can experience data corruption on Windows networks from Opportunistic Locking on servers and read Caching on clients. For developers using file system databases other than DataFlex's, visit Microsoft for more information about this issue, or consider consulting with our Professional Services experts for application development assistance with resolving this issue.
with Microsoft SQL Server being the most popular choice. SQL database s do not suffer from the OpLock risks or recent changes to the SMB protocols.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}