성능 테스트 ‐ 랭킹

랭킹 - DB

유저 1000명

Type	Name	50%	66%	75%	80%	90%	95%	98%	99%	99.9%	99.99%	100%	# reqs
GET	/api/v1/lottery/drawing/rank?subEventId=4	17	25	31	37	55	81	160	850	2300	2800	2900	98636
	Aggregated	17	25	31	37	55	81	160	850	2300	2800	2900	98636

유저 50,000 명

Response Time Percentiles (Approximated)

Type	Name	50%	66%	75%	80%	90%	95%	98%	99%	99.9%	99.99%	100%	# reqs
GET	/api/v1/lottery/drawing/rank?subEventId=4	31000	40000	45000	47000	53000	56000	57000	58000	59000	59000	59000	953
	Aggregated	31000	40000	45000	47000	53000	56000	57000	58000	59000	59000	59000	953

Error Report

# occurrences	Error
19	GET /api/v1/lottery/drawing/rank?subEventId=4: HTTPError('500 Server Error: for url: /api/v1/lottery/drawing/rank?subEventId=4')

인덱스 game_score, subEventId

Response time percentiles (approximated) Type Name 50% 66% 75% 80% 90% 95% 98% 99% 99.9% 99.99% 100% # reqs --------|--------------------------------------------------------------------------------|--------|------|------|------|------|------|------|------|------|------|------|------ GET /api/v1/lottery/drawing/rank?subEventId=4 9 13 18 23 47 270 1100 1200 1500 1600 1600 19812 --------|--------------------------------------------------------------------------------|--------|------|------|------|------|------|------|------|------|------|------|------ Aggregated 9 13 18 23 47 270 1100 1200 1500 1600 1600 19812

5000명

Redis 사용 랭킹 조회

1000 명

Response Time Percentiles (Approximated)

Type	Name	50%	66%	75%	80%	90%	95%	98%	99%	99.9%	99.99%	100%	# reqs
GET	/api/v1/lottery/drawing/rank?subEventId=4	11	16	23	29	60	650	1700	1900	2300	2700	2700	19607
	Aggregated	11	16	23	29	60	650	1700	1900	2300	2700	2700	19607

5000 명

Response Time Percentiles (Approximated)

Type	Name	50%	66%	75%	80%	90%	95%	98%	99%	99.9%	99.99%	100%	# reqs
GET	/api/v1/lottery/drawing/rank?subEventId=4	2200	2600	2900	3000	3700	5300	5900	26000	56000	61000	61000	49941
	Aggregated	2200	2600	2900	3000	3700	5300	5900	26000	56000	61000	61000	49941