Manual talk:Image table
Add topicLatest comment: 5 years ago by Jean-Frédéric in topic img_user
Remove Enums
[edit]- Just an idea, from a MS-SQL 2008 dba, why not remove the overhead of the ENUM field types (media_type & major_mime) and make them a reference type to a table, maybe called 'enums', or whatever name you choose. You could consolidate all your ENUM field types out of the tables and into this one single repository.
- Maybe have a signatures such as, for the enum table:
- id
- (INT ? SMALLINT) control field, either auto-increment or value controlled through system.
- type
- (VARCHAR(50)) identifying type (such as 'media_type', 'major_mime')
- value
- (VARCHAR(255)) value the type could have
- Just a thought as a future-dev.
- Goldbishop 06:20, 27 February 2011 (UTC)
- A few notes: strict normalisation is not always good, for example extra JOIN can impact performance. And in general, MSSQL doesn't always behave like MySQL, so experience with it does not automatically translate. Max Semenik 10:56, 27 February 2011 (UTC)
- I get paid to work in MSSQL, but i dable in MySQL/P-SQL/Oracle. In MSSQL, we are sorta forced to it and since its what i get paid to do, wondered if it would better to co-locate all the ENUMS. Its all good and thanx for the quick reply. Goldbishop 13:40, 27 February 2011 (UTC)
- A few notes: strict normalisation is not always good, for example extra JOIN can impact performance. And in general, MSSQL doesn't always behave like MySQL, so experience with it does not automatically translate. Max Semenik 10:56, 27 February 2011 (UTC)
Can we get Manual:Image_table#Schema_summary to not look terrible on a narrow screen?
[edit]MW131tester (talk) 12:54, 6 February 2019 (UTC)
img_user
[edit]Just a quick line here, having been bitten by this myself: Per phab:T167246, img_user was removed from this table for img_actor. Jean-Fred (talk) 13:12, 3 June 2019 (UTC)