The ResourceOptions property has the following sub-properties:
- CmdExecMode and CmdExecTimeout: A very common issue I have seen developers asking about on forums is about how to avoid the application from freezing while performing a time-consuming SQL operation (opening a large table or executing a not-so-fast query). Around the same topic, there is a second question, how do you cancel a long SQL operation from the client side?
Both questions deal with the command execution mode and the fact that most data access libraries are blocking and single-threaded. We'll learn about parallel programming in Chapter 11, Building Responsive Applications, and how to achieve responsiveness in blocking scenarios, but there is a very handy feature that FireDAC has. Through CmdExecMode, you can choose among some built-in implementation that may help you avoid UI blocking and at the same time give you a chance to cancel a long...