on 05-11-2015 3:24 PM
Hi,
I am currently struggling with the built-in SAP HANA Currency Conversion. If I enable a single column for currency conversion and use it in my query instead of the original column/measure the run-time of the query slows down by about 4 times. So instead of 3 second the query now runs ~12 seconds with the measure that uses currency conversion.
I already limited the TCURR and TCURF to only include relevant exchange rates (7.5M rows vs. 2.5M rows) which already saved me ~5 seconds per query
I also tried to changed the tables from column-tables to row-tables but this was just a test and made the performance even worse (>30 seconds)
So my question is how I could tune that?
Can anyone provide to original SQL create scripts for the TCUR tables from SAP?
Would it help to create any indexes?
What other options do I have to tune currency conversino?
thanks in advance!
-gerhard
Ding Ding..is this still a performance issue, currency conversion that is?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.