성능 테스트 ‐ 랭킹

랭킹 - 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

---

고정된 랭킹 조회

5000 - 5000 Redis 랭킹

Type	Name	# Requests	# Fails	Median (ms)	95%ile (ms)	99%ile (ms)	Average (ms)	Min (ms)	Max (ms)	Average size (bytes)	Current RPS	Current Failures/s
GET	/api/v1/lottery/drawing/rank?subEventId=4	162137	0	3700	6200	43000	5024.63	23	221840	929	535.3	0
	Aggregated	162137	0	3700	6200	43000	5024.63	23	221840	929	535.3	0

1000 - 1000 DB 랭킹 (index)

Type Name # Requests # Fails Median (ms) 95%ile (ms) 99%ile (ms) Average (ms) Min (ms) Max (ms) Average size (bytes) Current RPS Current Failures/s GET /api/v1/lottery/drawing/rank?subEventId=4 115935 0 11 130 890 45.43 3 1648 1001 329.1 0 Aggregated 115935 0 11 130 890 45.43 3 1648 1001 329.1 0

5000 - 5000 DB 랭킹 (index)

Type	Name	# Requests	# Fails	Median (ms)	95%ile (ms)	99%ile (ms)	Average (ms)	Min (ms)	Max (ms)	Average size (bytes)	Current RPS	Current Failures/s
GET	/api/v1/lottery/drawing/rank?subEventId=4	157541	0	3900	6300	60000	5356.92	312	237923	1001	527.5	0
	Aggregated	157541	0	3900	6300	60000	5356.92	312	237923	1001	527.5	0

Test: 랭킹 업데이트까지