Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 58 of 58
What should I prefer to connect to SAP HANA database- extended services or other ODBC technique?
As you had already mentioned that extended services are natively integrated with HANA, so it’s going to be easier to use against HANA but as it is native to HANA only it can’t be used elsewhere. It will be faster when you compare it against ODBC because the extra step will be avoided here as it is native to HANA. Also, as it is integrated other factors like latency and other would be out of question which can be considerable factors with ODBC.Extended Services follow the MVC architecture so you need not worry about the implementation style as it will ...
Read MoreHow to upload a big CSV file in SAP Hybrid mobile app quickly?
As you said you are using the hot folder concept, you need to ensure that the proper threads are being used at every moment for any operation.By default, the number of threads used for import is one. To be more technical, impex.import.workers thread is one if not set explicitly. Since in your case the file is big, make sure that you exploit all the available cores to the fullest. It is highly recommended that maximum threads at any point of time should not be more than twice the number of cores. For optimal working, you may need to work out ...
Read MoreIs Partitioning required in SAP HANA tables for one million records?
I think you are over thinking on a potential issue. The size of tables as you said will be rarely over one million records which does not qualify it to be considered a big table. In my application we have tables which are much bigger than that but still work pretty well over time. Also, as you said that data is mainly categorized on a daily basis so, theoretically it makes sense to partition tables on dates. It should improve the performance to some extent. But it can also lead to good number of partitions which can backfire too from ...
Read More