search

MrMoon / Bloom

Hospital ERP with Data Analysis - Database Systems Course Project
0 stars 0 forks source link

Use serial IDs instead of UUIDs #12

Closed MrMoon closed 3 years ago

MrMoon commented 3 years ago

Serial IDs cost less in time for indexing

MrMoon commented 3 years ago

to elaborate more on it, As you insert into a table using a sequence, it simply appends the new value to the end of the index. When you insert into a table using a UUID for a primary key, it has to look up and insert the pointer into the index, potentially in the middle of a page, causing a page rewrite, and further index fragmentation.

MrMoon commented 3 years ago

We are good in the patient microservice

MrMoon commented 3 years ago

We are good in the employee microservice