Database Connectors

Connector type Minimum requirements Required fields Performance

Oracle

Driver version used: 12.2.0.1

To check the database versions supported by the driver, consult the official documentation

Example with AWS instance:

  • Type: t2.nano

  • OS: Amazon Linux AMI 2018.03 (Fedora)

  • Memory: 500 MB

  • CPU: 1 vCPU

  • Storage: 8 GiB

The minimum startup memory is 100 MB (which supports 25 requests/second).

  • User: <user>

  • Password: <password>

  • Database name: <database>

  • Role user: <role user>

  • AWS instance: <AWS instance>

  • Owner: <owner>¹

¹The "owner" is the intended database schema. If not informed, sys will be used.

  • Jmeter: Thread 500, loop 100

  • Memory: 200 mb

  • Samples: 100000

  • Average latency (ms): 5727

  • Throughput/second: 86.79

These are the performance data using the minimum requirements mentioned.

SQL Server

Driver version used: 7.2.2.jre8

To check the database versions supported by the driver, consult the official documentation

Example with AWS instance:

  • Type: t2.nano

  • OS: Amazon Linux AMI 2018.03 (Fedora)

  • Memory: 500 MB

  • CPU: 1 vCPU

  • Storage: 8 GiB

The minimum startup memory is 100 MB (which supports 25 requests/second).

  • User: <user>

  • Password: <password>

  • Database name: <database>

  • Host/AWS instance: <AWS instance>

  • Jmeter: Thread 500, loop 100

  • Memory: 200 mb

  • Samples: 50000

  • Average latency (ms): 862

  • Throughput/second: 504.3

These are the performance data using the minimum requirements mentioned.

MySQL - BETA version

Driver version used: 8.0.17

To check the database versions supported by the driver, consult the official documentation

Example with AWS instance:

  • Type: t2.nano

  • OS: Amazon Linux AMI 2018.03 (Fedora)

  • Memory: 500 MB

  • CPU: 1 vCPU

  • Storage: 8 GiB

We do not have final performance data for the BETA version of MySQL connector (including minimum start-up memory)
  • User: <user>

  • Password: <password>

  • Database name: <database>

  • Host/AWS instance: <AWS instance>

We do not have final performance data for the BETA version of MySQL connector.

Postgres

Driver version used: 42.2.18

To check the database versions supported by the driver, consult the official documentation

Example with AWS instance:

  • Type: t2.nano

  • OS: Amazon Linux AMI 2018.03 (Fedora)

  • Memory: 500 MB

  • CPU: 1 vCPU

  • Storage: 8 GiB

The minimum startup memory is 100 MB (which supports 25 requests/second).

  • User: <user>

  • Password: <password>

  • Database name: <database>

  • Host/AWS instance: <AWS instance>

  • Jmeter: Thread 900, loop 100

  • Memory: 200 mb

  • Samples: 90000

  • Average latency (ms): 2285

  • Throughput/second: 285.4

These are the performance data using the minimum requirements mentioned.

Thanks for your feedback!
EDIT
How useful was this article to you?