Hi everyone,
I have a scenario where i need to convert my internal table to JSON format and output from SAP NW system. I have several approach on this including ABAP and KERNEL level JSON conversion. I also have an option to push JSOn conversion to HANA DB level by using CL_SQL_STATEMENT class.
Based on my tests, 1.3 million record SBOOK table taking around 17 seconds to convert in HANA layer and not sure if entire output is correct. I decided to split this to 100K records and run 13 times. Still total duration is around that much.
I did same test by using opening cursor on ABAP level and reading data in 100K chunks. I can achive around 19-20 seconds with ABAP including data fetch + JSON conversion. Considering data fetch duration, i can say ABAP Kernel JSON conversion is much much more faster comparing to HANA DB level.
I haven't tested converting data to JSON in DB level and inserting to a table in DB level as well.
Is there anyway to speed up JSON conversion on DB level or did anyone notice the same issue ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.