Begin / end SQL in preemptive mode

Preemptive processes allow your applications to take full advantage of multi-core computers, resulting in faster responses to simultaneous requests. Beginning with 4D v17 R4, Begin SQL, End SQL, and the associated SQL statements used with an internal database are now preemptive compliant.

Before ORDA, many developers used Begin SQL and End SQL to work on a table without changing the current record. We’ve improved these commands to help you migrate your applications to preemptive mode. For example, if you use these commands to do a lot of asynchronous writings in your database, you can now start all your requests in parallel and increase the speed of your applications.

In the video below, you can see that preemptive mode increases the speed of your queries because all of the processors are engaged:



Fabrice Mainguené
• Product Owner •Fabrice Mainguené joined 4D Program team in November, 2016. As a Product Owner, he is in charge of writing the user stories then translating it to functional specifications. His role is also to make sure that the feature implementation delivered is meeting the customer need.After obtaining a Bachelor degree in Computer Science at CNAM, Fabrice joined a small software publishing company as a Windev developer. Then he worked for different companies in industry and trade areas as a Windev and web developer as well as technical advisor on new features.