Tips for improving the performance of the SAP HANA Output
adapter.
- Sybase recommends installing Event Stream Processor on a
different server than your SAP HANA server.
- Use a column based table instead of row based in SAP
HANA.
- Partitioning a column based table can improve the
performance of multi-threaded access to the table. Create sufficient
partitions that your SAP HANA server can handle.
- Adjusting the number of threads used to load data in
parallel, through the threadCount
property, can affect the throughput of the adapter. Sybase recommends that
you start the value at the number of partitions on the table into which you
are loading, and adjust higher up to approximately 5 times that number until
performance no longer improves. Keep in mind that there is a limit of 2
billion rows per partition in SAP HANA. See your SAP HANA documentation for
more details.
- If you are running on UNIX, use unixODBC 2.3.O as SAP HANA
supports this version only.
- Test optimum performance by setting different values for the
bulkBatchSize,
bulkInsertArraySize,
idleBufferWriteDelayMSec, and
bufferAgeLimitMSec properties.
- Increasing bulkBatchSize increases throughput but also
increases latency. Increase this number as needed based on what you require
for latency. If you increase bulkBatchSize, also
increase bulkInsertArraySize accordingly as
bulkInsertArraySize is a divisor of
bulkBatchSize.