UUID vs sequential primary key in Python

import uuid
import time

def create_record_with_uuid(name):
    record_id = uuid.uuid4()
    return {"id": record_id, "name": name}

def create_record_with_sequential_id(name, counter):
    counter += 1
    return {"id": counter, "name": name}

if __name__ == "__main__":
    # Simulate users inserting records
    sequential_counter = 0
    records = []

    start_time = time.time()
    for i in range(5):
        record = create_record_with_uuid(f"User_{i}")
        records.append(record)
    uuid_time = time.time() - start_time

    start_time = time.time()
    for i in range(5):
        record = create_record_with_sequential_id(f"User_{i}", sequential_counter)
        sequential_counter = record["id"]
        records.append(record)
    seq_time = time.time() - start_time

    print("UUID records (random order):")
    for r in records[:5]:
        print(f"  {r['name']}: {r['id']}")

    print("\nSequential records (predictable order):")
    for r in records[5:]:
        print(f"  {r['name']}: {r['id']}")

    print(f"\nUUID generation took {uuid_time:.6f}s")
    print(f"Sequential generation took {seq_time:.6f}s")
    print("Trade-off: UUIDs are globally unique but not ordered; sequential IDs are ordered but predictable.")