Pengujian Perfoma UUID Sebagai Primary Key Pada Database PostgreSQL Dan MongoDB
DOI:
https://doi.org/10.35870/jtik.v9i4.3878Keywords:
UUID, PostgreSQL, MongoDBAbstract
The selection of a primary key is crucial in database management, as it impacts database performance and scalability. This study aims to evaluate one of the trending types of primary keys among developers — UUID. The evaluation is conducted on two different databases, PostgreSQL and MongoDB, using auto-increment and MongoDB’s ObjectId as comparisons. The testing involves importing data from a CSV file and processing it in parallel to assess the efficiency of each primary key in handling data insertion. The results show that auto-increment has advantages in terms of speed and smaller storage size compared to UUID, especially in MongoDB. In PostgreSQL, the speed difference is not as significant, but auto-increment remains more efficient in storage usage. This study provides valuable insights for developers in selecting the appropriate primary key based on system performance requirements.
Downloads
References
Bhaswara, F. A., Sarno, R., & Sunaryono, D. (2017). Perbandingan Kemampuan Database NoSQL dan SQL dalam Kasus ERP Retail. Jurnal Teknik ITS, 6(2), A511-A514. https://doi.org/10.12962/j23373539.v6i2.24031.
Cahyani, A. D., Basuki, A., & Nafisah, D. (2022). Pengolahan Basis Data Mongo DB. Media Nusa Creative (MNC Publishing).
Cui, X., & Chen, W. (2021). Performance comparison test of HBase and Cassandra based on YCSB. In 2021 IEEE/ACIS 19th International Conference on Computer and Information Science (ICIS), 70–77. https://doi.org/10.1109/ICIS51600.2021.9516864.
Keighobad, A., & Demirel, F. B. (2021). Software Platform for Design and Management of Real-time Data from Microneedle-based Wearable Sensors: A front-end (iOS) and a server-side (Node. js) implementation for an IoT system.
Makris, A., Tserpes, K., Spiliopoulos, G., Zissis, D., & Anagnostopoulos, D. (2021). MongoDB Vs PostgreSQL: A comparative study on performance aspects. GeoInformatica, 25, 243-268.
Mishra, N., Chakraborty, A., & Mukhopadhyay, D. (2022, August). Breaking Cross-world isolation on ARM TrustZone through EM Faults, Coredumps, and UUID Confusion.
Nokeri, T. C. (2021). Python Web Frameworks and Apps. In Web App Development and Real-Time Web Analytics with Python: Develop and Integrate Machine Learning Algorithms into Web Apps (pp. 79-85). Berkeley, CA: Apress.
Pebrianto, J. (2022). Perbandingan Kecepatan Baca Dan Tulis Data Pada Mysql Menggunakan Primary Key Auto Increment Dengan Universally Unique Identifier (UUID). Media Jurnal Informatika, 14(2), 86-96. https://doi.org/10.35194/mji.v14i2.2681.
Prastowo, A. A., Purwadi, A., Murtono, T., Upe, A., Rusli, M., Hos, J., Moita, S., Wicaksono, G., Wan Khairuldin, W. M. K. F., & Sono, M. G. (2021). Application of decision support system using composite performance index algorithm. Journal of Physics: Conference Series, 1933(1), 012018. https://doi.org/10.1088/1742-6596/1933/1/012018.
Ravshanovich, A. R. (2024). DATABASE STRUCTURE: POSTGRESQL DATABASE. PSIXOLOGIYA VA SOTSIOLOGIYA ILMIY JURNALI, 2(7), 50-55.
Rumandan, R. J. (2022). Implementasi Composite Performance Index (CPI) Pada Sistem Pendukung Keputusan Pemilihan Mitra Pengiriman Barang. KLIK: Kajian Ilmiah Informatika Dan Komputer, 3(1), 17-25.
Salunke, S. V., & Ouda, A. (2024). A Performance Benchmark for the PostgreSQL and MySQL Databases. Future Internet, 16(10), 382. https://doi.org/10.3390/fi16100382.
Satria, B., Sidauruk, A., Wardhana, R., Al Akbar, A., & Ihsan, M. A. (2022). Penerapan composite performance index (CPI) sebagai metode pada sistem pendukung keputusan seleksi penerima beasiswa. The Indonesian Journal of Computer Science, 11(2). https://doi.org/10.33022/ijcs.v11i2.3056.
Silalahi, M. (2018). Perbandingan performansi database mongodb dan mysql dalam aplikasi file multimedia berbasis web. Computer Based Information System Journal, 6(1), 63-63. https://doi.org/10.33884/cbis.v6i1.574.
Timisela, H. (2024). PERBANDINGAN KINERJA JENIS-JENIS BASIS DATA NOSQL DALAM MANAJEMEN DATA BIOMEDIK= PERFORMANCE COMPARISON OF NOSQL DATABASE TYPES IN BIOMEDICAL DATA MANAGEMENT (Doctoral dissertation, Universitas Hasanuddin).
Triebel, D., Reichert, W., Bosert, S., Feulner, M., Okach, D. O., Slimani, A., & Rambold, G. (2018). A generic workflow for effective sampling of environmental vouchers with UUID assignment and image processing. Database, 2018. https://doi.org/10.1093/database/bax096.
Zhou, X., Chai, C., Li, G., & Sun, J. (2022). Database meets artificial intelligence: A survey. IEEE Transactions on Knowledge and Data Engineering, 34(3), 1096–1116. https://doi.org/10.1109/TKDE.2020.2994641.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Muhamad Kamal Shamlan, Sri Winarso Martyas Edi
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
