Configuring Memory Usage

When executing certain SQL operations on non-SQL data, the connector consumes memory. By default, the connector can use up to 1024MB of RAM to support these operations. You can configure the maximum amount of RAM that the connector uses to support SQL operations on non-SQL data. If the amount of memory required exceeds the maximum, then the connector uses disk space to support the operation.

Note:

This setting applies to all connections that use the Simba DynamoDB JDBC Driver.

To configure memory usage:

  • Add the following argument to your JVM configuration, where [Value] is the amount of RAM in megabytes (MB) that the connector can use to support SQL operations on non-SQL data:
  • -Djsqlengine.swap.memory=[Value]