[MXS-3593] Use multi statement when inserting documents Created: 2021-06-04 Updated: 2021-09-02 Resolved: 2021-06-15 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | nosqlprotocol |
| Affects Version/s: | 6.0.0 |
| Fix Version/s: | 6.0.0 |
| Type: | Task | Priority: | Major |
| Reporter: | Johan Wikman | Assignee: | Johan Wikman |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Epic Link: | MongoDB Protocol Support |
| Sprint: | MXS-SPRINT-133 |
| Description |
|
Currently, if the insert_behavior is as_nosql, that is, nosqlprotocol behaves just like MongoDB, there will be as many INSERT statements and roundtrips (between MaxScale and the backend) as there are documents. If multi-statements are used, the number of roundtrips could be cut down to 1, which should have a significant impact on the performance. If insert_behavior is as_mariadb, there will be just one INSERT statement and 1 roundtrip, which is likely to continue providing the best performance. |