I am extending an API to include the ability to retrieve and update a specific record after the record is created by the user.
Currently, these records are created with an auto generated integer key, for example
Users need a way to access a specific record but I don't like the idea of exposing this ID to end users, because it will reveal information about my schema, for example I can assume there is also a record of ID
I'm considering a GUID alongside the auto generated integer, but I have concerns about performance as the table size is ~5 million records, growing by 1 million/year.
Is there reason for concern adding a table this size, or the subsequent SELECT query on the GUID when retrieving/updating the record?
I'm using AWS RDS MySQL.