| Batch Size | Simple Insert Execution Time (ms) | Multi-Row Insert Execution Time (ms) | Improvement |
|---|---|---|---|
| 1 | 4 | 3 | 33% |
| 10 | 15 | 4 | 275% |
| 50 | 68 | 3 | 2167% |
| 100 | 133 | 4 | 3225% |
| 250 | 306 | 6 | 5000% |
| 500 | 606 | 8 | 7475% |
| 1000 | 1358 | 11 | 12,245% |
| 2500 | 3527 | 28 | 12,496% |
| 5000 | 6587 | 56 | 11,663% |
| 10,000 | 11,448 | 95 | 11,951% |
| 25,000 | 29,155 | 225 | 12,858% |
| 50,000 | 58,897 | 481 | 12,145% |
| 100,000 | 120,394 | 1017 | 11,738% |
Created
February 2, 2023 21:09
-
-
Save jasonmitchell/62c54d43b30b8d3c001fe2a7e84905d2 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment