Re:"We ran out of columns" – The best, worst codebase
by nextaccountic on Sunday August 04, 2024 @02:39PM
(#41155427)
It's the same thing actually
https://stackoverflow.com/questions/41928749/pros-cons-of-re...
But of course, the obvious solution is to have one table with just ROWID and data, and another table with the friendly IDs! If you time the insertions really well, then the ROWIDs in both tables with match and voilà.