Hi all
I have a question about trafodion insert that if trafodion executes query ‘insert into table
values(i),(i+1)…,(i+100)’ N/100 times faster than executing query ‘insert into table
values(i) N times. So I made a simple test:
I used jdbcT4 to execute query ‘insert into song values(i)’ 10K times (i from 1 to 10K,
10k rows)and it cost about 89 seconds. Then I executed query ‘insert into song values(i),(I
+1),…,(i+100)’ 100 times(total of 10,000 rows) and it cost about 8.6 seconds.
I am not sure if it only because simple 1 needs to send buffer to mxosrvr 10k times. But I
am more concerned about if query ‘insert into table values(i),(),(),(I + N)’ will be executed
faster in sql engine than executing ‘insert into table values(i)’ N times.
Besides, how will the engine handle query ‘insert into table values(a),(b),(c)’? Will
engine use execute plan cache?
Best,
宋昊霖 （Haolin(Leo) Song）
|