Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Jurnal JTIK (Jurnal Teknologi Informasi dan Komunikasi)
Muhamad Kamal Shamlan
Universitas Kristen Satya Wacana
Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Pengujian Perfoma UUID Sebagai Primary Key Pada Database PostgreSQL Dan MongoDB Muhamad Kamal Shamlan; Sri Winarso Martyas Edi
Jurnal JTIK (Jurnal Teknologi Informasi dan Komunikasi) Vol 9 No 4 (2025): OCTOBER-DECEMBER 2025
Publisher : Lembaga Otonom Lembaga Informasi dan Riset Indonesia (KITA INFO dan RISET)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.35870/jtik.v9i4.3878

Abstract

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.
Co-Authors Sri Winarso Martyas Edi