By Anonymous (not verified) on
I am developing a module which table rows a 1 to 1 related to user table rows. Should I load this table with every user load (which results in a lot of additional loads if comments or user list is displays), or alter the user table during module installation? If I should alter it, how can I do it with the installation schema?
Comments
Alter Table
It's generally accepted that it's a bad idea to hack core (code or tables). Add a table specific to your mod (and preface it if you like with something that says it's your mod) and do a join. It might take a slight performance hit but not much and if you upgrade to a newer version of drupal down the road it won't undo all your work.