Home | DataFlex | Contact

Opportunistic Locking and Read Caching on Microsoft Windows Networks

Strategies for Database Application Developers

Last Edited: 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 OpLocks 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.

• For Data Access Worldwide customers still using the DataFlex embedded file system database, read the Knowledge Base article that discusses these Windows network behaviors, their effects, and what can be done to reduce the chances of data corruption until a transition to SQL is accomplished.

• Learn more about the features of DataFlex SQL Connectivity Kits.

• Our Professional Services group's services include assistance with embedded to SQL database migrations if needed.