Skip to Content
0
Sep 19, 2016 at 08:28 AM

oracle insert faster then insert sap hana ?

152 Views

Hello hana experts !

I nead to regylar load geodata in sap hana and store. Now it works in oracle.

The aim is to load in to table hana faster then oracle table.

in oracle(my local machine):

i have a table

create table UDO_TEST1

(

id NUMBER,

wlat NUMBER,

wlong NUMBER

);

insert table

insert 1000 records performed for 0.032 s.

in hana ( server )

i have column table

CREATE COLUMN TABLE "SCHEMA"."ROW_TABLE_TEST1" ("ID" INTEGER CS_INT,

"WLAT" DOUBLE CS_DOUBLE,

"WLONG" DOUBLE CS_DOUBLE) UNLOAD PRIORITY 5 AUTO MERGE PARTITION BY 'RANGE ID 1-500,501-1000,*'

insert into table

insert 1000 records performed for 0.579 s.🤯



if i have a row table insert performed for 0.160 s. (oracle 0,032 s.)


How do I get insert to the table hana faster than Oracle, maybe someone has a similar experience ? I nead to load data on regular basis.


Attachments

1.png (24.6 kB)
2.png (8.8 kB)
3.png (8.5 kB)