A Performance Analysis: Evaluating Relational Database System on HDD VS. SSD Storage

Database speed depends on how fast systems read and write data. Storage hardware plays a major role in this process. This study compares Hard Disk Drives and Solid-State Drives to see which handles database tasks better. HDDs use moving parts and spinning platters. These mechanical parts create delays when the system looks for data. SSDs use flash memory. This design allows for faster access and shorter wait times. This research used a descriptive method to gather information. The process involved running basic database tests and surveying IT lecturers. The tests measured query response times and data loading speeds. They also tracked disk write speeds. The survey asked lecturers about common problems they see in school computer labs. Results show SSDs perform better in every category.

Query responses happen faster. System lag disappears. The findings prove storage type has a strong effect on database efficiency. Even simple systems show better results when using SSDs. IT lecturers reported fewer system crashes and faster boot times when using flash storage. Students finished their tasks faster when the lab computers used newer drives. HDDs struggle with random data access because the physical head must move to the correct spot on the disk. SSDs skip this step. Large data sets load in half the time when using an SSD. Database will handle more users at once without slowing down. This study helps students and schools understand why hardware choice matters. You get better performance by choosing the right drive. Proper hardware reduces frustration for developers and users. High speed storage makes database management easier for everyone. Your system stays stable even under heavy workloads. Investing in SSD technology improves the learning experience in technical courses. Hardware limitations should not stop your progress. Choose SSDs to ensure your database runs at its best speed. Better hardware leads to better results for your projects.

Database Performance, HDD, SSD, Query Speed, Storage, Data Loading, Disk speed

1. IBM. (2025). Hard disk drive (HDD) vs. solid-state drive (SSD). https://www.ibm.com/think/topics/hard-disk-drive-vs-solid-state-drive [Google Scholar] [Crossref]

2. Intel. (2023). Introduction to solid-state drives. https://www.intel.com/content/www/us/en/products/docs/memory-storage/solid-state-drives/what-is-an-ssd.html [Google Scholar] [Crossref]

3. Kingston Technology. (2023). SSD vs HDD: What’s the difference? https://www.kingston.com/en/blog/pc-performance/ssd-vs-hdd [Google Scholar] [Crossref]

4. MDPI. (2024). Revisiting database indexing for parallel and accelerated computing: A comprehensive study and novel approaches. Information, 15(8), 429. https://www.mdpi.com/2078-2489/15/8/429 [Google Scholar] [Crossref]

5. ResearchGate. (2024). Comparison performance analysis of HDD, SSD, and NVMe for OLTP database server. https://www.researchgate.net/publication/385426961 [Google Scholar] [Crossref]

6. Samsung Electronics. (2023). SSD vs HDD: What’s the difference? https://www.samsung.com/semiconductor/minisite/ssd/product/consumer/ssd-vs-hdd/ [Google Scholar] [Crossref]

7. Seagate Technology. (2022). SSD vs HDD: What’s the difference? https://www.seagate.com/blog/ssd-vs-hdd/ [Google Scholar] [Crossref]

8. TechTarget. (2024). Solid-state drive (SSD). https://www.techtarget.com/searchstorage/definition/SSD [Google Scholar] [Crossref]

9. Tencent Cloud. (2026). What are the differences in the impact of SSDs and HDDs on retrieval performance? https://www.tencentcloud.com/techpedia/141916 [Google Scholar] [Crossref]

10. Western Digital. (2022). HDD vs SSD: What’s the difference? https://www.westerndigital.com/solutions/hdd-vs-ssd [Google Scholar] [Crossref]

• Performance Analysis of Silicon PV Array Using Infrared Thermography and Detecting Temperature Non-Uniformities
• Dynamic Capabilities and Digital Transformation Performance: The Role of Organizational Agility in the Public Sector
• Comparative Effectiveness of Neural Mobilization Versus Positional Release Technique in Cervical Radiculopathy – An Experimental Study
• Soil Moisture Mapping of Solano Nueva Vizcaya: A Comparison and Review
• Silent Assistance for Emergencies (SAFE): A Mobile-Based Emergency Reporting Application for the Deaf and Mute Community