Skip to Content

oracle insert faster then insert sap hana ?

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.


1.png (24.6 kB)
2.png (8.8 kB)
3.png (8.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 19, 2016 at 09:14 AM

    Viktor Portyankin wrote:

    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.

    Well, I'd start with a realistic test scenario.

    Your loop insert in Oracle will very likely be optimised by PL/SQL into one big bulk insert.

    SQLScript doesn't do this and ends up with 1000 single inserts.

    That way you're not testing the insert speed but the ability to short circuit static loops.

    Alternatively you could write a INSERT FROM SELECT where you create the tuples in the select and pass this in one INSERT statement.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.