Query Performance Improvement Member Name Duplication Check

Data Specifications

• Members: 10 records
• Categories: 100 records (10 records per member)
• Tags: 2000 records (200 records per member)
• Templates: 100,000 records (10,000 records per member)
• Source Code: 100,000 to 500,000 records (1 to 5 randomly generated per template)

Computer Specifications

• Operating System: Windows 11
• Processor: AMD Ryzen 9 4900HS with Radeon Graphics, 3.00 GHz
• Installed RAM: 16.0 GB
• System Type: 64-bit operating system, x64-based processor

Test Conditions

• Executed with 10 threads, 100 times each
• Total of 1000 requests executed
• Maximum test wait time: 60 seconds

---

Before Improvement

Speed Measurement

• Total request count: 1000
• Total elapsed time: 16021 ms
• Average elapsed time: 16 ms

Query Analysis

1. Lookup by Member ID (based on name)

• Repository: MemberJpaRepository
• Method: existsByName

select
    m1_0.id 
from
    member m1_0 
where
    m1_0.name=? 
limit
     ?

• Number of Calls: 1

---

Required Tasks for Improvement

• No improvements necessary