How to Perform Performance Tuning in SAP HANA Client?
We can enable or change a number of client features in order to improve and enhance the performance of an application connected to SAP HANA database.
If WAN (Wide Area Network) is used by any application in order to connect with SAP HANA server, then SAP recommend a network compression which can result in significantly improve performance (in some cases, it doubles the performance of the application).
If LAN (Local Area Network) is used by any application in order to connect with SAP HANA server then also performing a network compression often result in improved performance but in some cases, there is a risk for some applications and networks that it may decrease performance.
Note: Client and Server both need to have at least SAP HANA 2 SPS 02 or higher in order to use network compression.
Result Set Prefetch
The result set prefetch improves the performance while fetching large result sets. The result set prefetch is available in starting in SAP HANA 2 SPS 01 for SQLDBC-based client interfaces (including ODBC and ADO.NET), and in SAP HANA 2 SPS 02 for JDBC.
SAP HANA clients sometimes break the request into multiple requests based on the packet size.
For instance, SQLDBC-based clients from SAP HANA 1 SPS 08 and JDBC-based clients from SAP HANA 2 SPS 02 use the packet size for determining the size of the fetch blocks in order to request from the server.
Note: In the case of JDBC, increasing the packet size significantly sometimes result in out of memory conditions even if your computer has a large amount of memory available.