Configuring Memory Usage

Some SQL operations, when applied to non-SQL data, require data to be cached temporarily before they can be completed. You can configure the Memory Manager feature in the connector to restrict the amount of RAM or disk space that the connector can use to cache data. For more information, see Memory Manager.

Important:
  • By default, when data is cached as a file on disk, it is stored as unencrypted data. For information about encrypting this data to prevent security risks, see Encrypting Swap Files.
  • Typically, connector-wide configuration settings (such as the settings for the Memory Manager) are applied to all connections that use the connector. However, if the connector uses the RDFODBC dependency, then connector-wide configuration settings are applied to all connectors that also use the RDFODBC dependency.

To configure memory usage:

  1. From the /lib subfolder in the connector installation directory, do one of the following:
    • If the connector is using the RDFODBC dependency, then open the rdf.rdfodbc.ini configuration file in a text editor.
    • Otherwise, open the simba.paypalodbc.ini configuration file in a text editor.
  2. Set the properties as follows:
    PropertyValue

    MemoryManagerMemoryLimit

    The maximum amount of RAM in megabytes (MB) that the connector can use to cache data for SQL operations.

    MemoryManagerThresholdPercent

    The maximum percentage of the memory limit that can be used by an existing operation. The remaining memory limit is reserved for new operations.

    MemoryManagerStrategy

    One of the following numbers specifying how the connector restricts RAM usage and manages operations when more RAM is required:

    • 1: The connector does not use any disk space to support SQL operations.
    • 2: The connector restricts the amount of RAM that each operation can use, and uses swap files to support operations if more memory is required.
    • 3: The connector allows the first SQL operation to consume as much RAM as necessary from the amounts specified by the memory limit and threshold, while subsequent operations use the remaining amount.

    SwapFilePath

    The full path to the directory where the connector creates swap files to temporarily cache data on disk.

    MemoryManagerSwapDiskLimit

    The maximum total size of all the swap files, in megabytes (MB).

    When this option is set to 0, there is no limit to the size of the swap files.

    For more information about each of these settings, including recommendations for setting the MemoryManagerStrategy property, see Connector Configuration Properties.

  3. Save the configuration file.