Timeline for Should we add extra 5 columns or build a separate table?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 15, 2012 at 13:51 | comment | added | newbie14 | @rolando actually this table receives data from gps devices which are comma delimited. The number of data when broke down is 26 altogether and the rest of the 7 more fields are id which are foreign key of different tables and not all are filled depends on the event message represented by the string. So that is why we having problem with normalisation. So is it ok not to normalize in this case? | |
| Jun 14, 2012 at 17:34 | comment | added | RolandoMySQLDBA | @jcolebrand A view would just hide the gory details of messy SQL under the hood. Once such views are written, it would appear to be smooth sailing from there until it is time to purge old data from the table, or should I say tables (as long as newbie is OK with that). | |
| Jun 14, 2012 at 17:27 | comment | added | jcolebrand♦ | Or they could use a view? | |
| Jun 14, 2012 at 17:15 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |