성능 테스트 ‐ 랭킹

랭킹 - 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 사용 랭킹 조회

5000 명

Locust Test Summary

Requests Summary

Type	Name	# reqs	# fails	Avg	Min	Max	Med	req/s	failures/s
GET	/api/v1/lottery/drawing/rank?subEventId=4	200432	0 (0.00%)	4443	16	188717	3700	563.87	0.00
	Aggregated	200432	0 (0.00%)	4443	16	188717	3700	563.87	0.00

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	3700	4300	4600	4800	5300	5700	6200	6700	163000	185000	189000	200432
	Aggregated	3700	4300	4600	4800	5300	5700	6200	6700	163000	185000	189000	200432