Unable to extend sys_user table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2020 07:33 AM
In my Orlando instance, I am unable to extend the sys_user table. When I check the sys_user table, the extensible checkbox is false... Is this default feature in Orlando or issue in my instance?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-09-2022 10:17 AM
FYI - Over the last year it has become apparent that extending from sys_user can lead to undesirable results.
See Nia Cash and Jace Benson's blog posts that explain how this could force a user to have two accounts - as was explained in the SNDevs slack community:
https://jace.pro/post/2021-08-12-extending-user-is-bad/
There is also a performance concern as reference auto-complete and lookup on the sys_user table are very frequent and resource intensive operations. It has been found that in some cases these operations do not perform well when the table size of sys_user reaches around 1 million. The exact size of the table necessary to cause performance issues will be influenced by many factors including the complexity of reference qualifiers or auto-complete settings and, thus, performance issues might be observed at smaller sizes. Conversely if auto-complete and reference qualifiers are highly optimized and efficient, then performance might be maintained even at larger sizes.
Please ✅ Correct if this solves your issue and/or 👍 if Helpful
"Simplicity does not precede complexity, but follows it"