ballerina-platform/ballerina-library

Write load tests for `persist.sql`

Opened this issue · 1 comments

Description:
This task is to write load tests for the persist.sql module to measure the performance of bal persist with SQL databases.

Describe your task(s)

  • Study JMeter and Kubernetes
  • Prepare sample database and the REST service
  • Run the tests on a controlled cloud environment

Load tests were done comparing the performance of bal persist with SQL, Ballerina MySql connector and also the Java framework Spring Boot. While the insert queries showed no real difference in performance between the three options, data retrievals suffered a performance degradation when using with bal persist. This issue is being investigated.

Source code for the load tests and test scripts can be found at [1].

[1] https://github.com/hasathcharu/persist-sql-load-tests/