DEV Community

loading...

Discussion on: From monolith to cloud: Auto Increment to UUID

Collapse
rafalpienkowski profile image
Rafal Pienkowski

There is one point here:

"Entries in a relational database like MySql/SQL/Oracle are usually identified by an incremental, unique (to table) number int(2232). The server collects the parameters, sends an INSERT(...) statement and the database generates a new ID (the next incremental value) and returns it."

Unfortunately, Oracle (unlike MS SQL, MySql) doesn't support an auto-increment data type. You have to create a combination of sequence and trigger for the PR key column. If I good remember Oracle decided to resign from that type of data structure due to performance reasons.

Collapse
bgadrian profile image
Adrian B.G. Author

They got that right, auto increment is a bottle neck in a heavy-write app. But still is funny to see the words Oracle and Performance in the same sentence.