SQL

INSERT Set

형식: INSERT INTO DATATYPE VALUES('KEY','VALUE')
예 : INSERT INTO SET VALUES('KEY','VALUE')

SET 입력

Set key, value를 입력합니다. insert into set values('myset1','value1' [,'value2'])
1 row(key, value) 입력: insert into set values('myset1','value1','value2')
이것은 SADD 명령의 작동과 동일합니다.
여러 row 입력: insert into set values('myset2','value1','value2'), ('myset3','value1','value2')

Example

명령>	insert into set values('myset1','value1','value2'); opcode
결과>	1 inserted
명령>	insert into set values('myset2','value1','value2'), ('myset3','value1','value2'); opcode
결과>	2 inserted

Performance 성능

Set

for i in {1..10000}; do src/redis-ecli -p 7000 sadd myset1 value$i; done -> 1.17us
for i in {1..10000}; do src/redis-ecli -p 7000 insert "insert into set values('myset2','value$i')"; done -> 24.29us
20개 value 입력
for i in {1..10000}; do src/redis-ecli -p 7000 sadd myset1 AAA$i BBB$i CCC$i DDD$i EEE$i FFF$i GGG$i HHH$i III$i JJJ$i AAX$i BBX$i CCX$i DDX$i EEX$i FFX$i GGX$i HHX$i IIX$i JJX$i; done; -> 10.94us
for i in {1..10000}; do src/redis-ecli -p 7000 insert "insert into set values('myset2','AAA$i','BBB$i','CCC$i','DDD$i','EEE$i','FFF$i','GGG$i','HHH$i','III$i','JJJ$i', 'AAX$i','BBX$i','CCX$i','DDX$i','EEX$i','FFX$i','GGX$i','HHX$i','IIX$i','JJX$i')"; done; -> 39.71us

각각 1만회 실행 평균 소요 시간(단위: us(microsecond))

Datatype	구분	개수	성능
Set	SADD	1	1.17us
	INSERT	1	24.29us
	SADD	20	10.94us
	INSERT	20	39.71us

OPCODE

insert into set values('myset1','value1','value2');

# ------------------------------------------------------- # insert into set values('myset1','value1','value2'); # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:1,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode:121 OP_Insert, p1:0,p2:5,p3:1,p4type:TABLE # opcode: 91 OP_MakeRecord, p1:2,p2:3,p3:5,p4type:NOTUSED # opcode:120 OP_NewRowid, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:4,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:3,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:2,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 97 OP_OpenWrite, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 62 OP_Init, p1:0,p2:9,p3:0,p4type:NOTUSED # sql:"insert into set values('myset1','value1','value2');" -> 1 inserted # used_memory:1290840, total_diff:24

insert into set values('myset2','value1','value2'), ('myset3','value1','value2');

# ------------------------------------------------------- # insert into set values('myset2','value1','value2'), ('myset3','value1','value2'); # ------------------------------------------------------- # opcode: 11 OP_Goto, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 2 OP_Transaction, p1:0,p2:1,p3:0,p4type:INT32 # opcode: 68 OP_Halt, p1:0,p2:0,p3:0,p4type:NOTUSED # opcode: 11 OP_Goto, p1:0,p2:12,p3:0,p4type:NOTUSED # opcode:121 OP_Insert, p1:0,p2:6,p3:1,p4type:TABLE # opcode: 91 OP_MakeRecord, p1:2,p2:3,p3:6,p4type:NOTUSED # opcode:120 OP_NewRowid, p1:0,p2:1,p3:0,p4type:NOTUSED # opcode: 14 OP_Yield, p1:5,p2:17,p3:0,p4type:NOTUSED # opcode: 97 OP_OpenWrite, p1:0,p2:0,p3:0,p4type:TABLE # opcode: 66 OP_EndCoroutine, p1:5,p2:0,p3:0,p4type:NOTUSED # opcode: 14 OP_Yield, p1:5,p2:0,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:4,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:3,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:2,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 14 OP_Yield, p1:5,p2:0,p3:0,p4type:NOTUSED # opcode:115 OP_String8, p1:0,p2:4,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:3,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode:115 OP_String8, p1:0,p2:2,p3:0,p4type:FREE_IF_LE/DYNAMIC # opcode: 13 OP_InitCoroutine, p1:5,p2:11,p3:2,p4type:NOTUSED # opcode: 62 OP_Init, p1:0,p2:18,p3:0,p4type:NOTUSED # sql:"insert into set values('myset2','value1','value2'), ('myset3','value1','value2');" -> 2 inserted # used_memory:1290880, total_diff:24

<< Insert List	Insert Set	Insert ZSet >>

Email 返事がかかってなれば、メールでお知らせします。