[CAM-8327] Switch on MyBatis batch processing mode Created: 16/Oct/17 Updated: 23/Feb/18 Resolved: 07/Nov/17
|Fix Version/s:||7.8.0, 7.8.0-alpha6|
|Type:||Task||Priority:||L3 - Default|
|Reporter:||Svetlana Dorokhova||Assignee:||Yana Vasileva|
|Remaining Estimate:||0 minutes|
|Time Spent:||Not Specified|
|Original Estimate:||0 minutes|
MyBatis has the special mode of pprocessing SQL statements in batches.
The task is:
|Comment by Svetlana Dorokhova [ 19/Oct/17 ]|
Performance test consisted of the following:
1. FULL history level
3. Process is started with 500 process variables. 1st Service task does nothing, but the transaction is committed after it is completed (asyncAfter). 2nd service task update all 500 process variables with new values and the transaction is committed afterwards. 3rd service task removes all the variables and process finishes.
The testing was done with the help of QA Performance test suite. It was running the test in 2 threads with 50 repeations. The result are the following:
It looks like MySQL does not distinguish batch and not batch operations, but SQL Server and Oracle do.
|Comment by Svetlana Dorokhova [ 20/Oct/17 ]|
Won't work for Oracle < 12.
This means that we won't be able to use optimistic locking with Batch processing switched on on Oracle earlier than v. 12.