A Performance Analysis: Evaluating Relational Database System on HDD VS. SSD Storage
Article Sidebar
Main Article Content
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.
Downloads
References
IBM. (2025). Hard disk drive (HDD) vs. solid-state drive (SSD). https://www.ibm.com/think/topics/hard-disk-drive-vs-solid-state-drive
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
Kingston Technology. (2023). SSD vs HDD: What’s the difference? https://www.kingston.com/en/blog/pc-performance/ssd-vs-hdd
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
ResearchGate. (2024). Comparison performance analysis of HDD, SSD, and NVMe for OLTP database server. https://www.researchgate.net/publication/385426961
Samsung Electronics. (2023). SSD vs HDD: What’s the difference? https://www.samsung.com/semiconductor/minisite/ssd/product/consumer/ssd-vs-hdd/
Seagate Technology. (2022). SSD vs HDD: What’s the difference? https://www.seagate.com/blog/ssd-vs-hdd/
TechTarget. (2024). Solid-state drive (SSD). https://www.techtarget.com/searchstorage/definition/SSD
Tencent Cloud. (2026). What are the differences in the impact of SSDs and HDDs on retrieval performance? https://www.tencentcloud.com/techpedia/141916
Western Digital. (2022). HDD vs SSD: What’s the difference? https://www.westerndigital.com/solutions/hdd-vs-ssd
This work is licensed under a Creative Commons Attribution 4.0 International License.
All articles published in our journal are licensed under CC-BY 4.0, which permits authors to retain copyright of their work. This license allows for unrestricted use, sharing, and reproduction of the articles, provided that proper credit is given to the original authors and the source.