When multiple messages are to be processed by the 'insert' action each message will be inserted as a single statement. A typical improvement for this is to make bulk insert available.
Therefore the component would need 2 more options in the 'insert' action.
- 'Bulk insert' a check box to enable the behaviour
- 'Bucket size' the amount of messages to be combined into one bulk insert
Here are pseudocode sample of single inserts and bulk inserts.
Single insert: insert into <table name> (col_1, ... , col_n) values (val_1, ... , val_n);
Bulk insert: insert into <table name> (col_1, ... , col_n) values (val_1_1, ... , val_1_n), ... , (val_m_1, ... , val_m_n);
When multiple messages are to be processed by the 'insert' action each message will be inserted as a single statement. A typical improvement for this is to make bulk insert available.
Therefore the component would need 2 more options in the 'insert' action.
Here are pseudocode sample of single inserts and bulk inserts.
Single insert:
insert into <table name> (col_1, ... , col_n) values (val_1, ... , val_n);Bulk insert:
insert into <table name> (col_1, ... , col_n) values (val_1_1, ... , val_1_n), ... , (val_m_1, ... , val_m_n);