Manual talk:Image table

Remove Enums

 * 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)