Timeline for When should a database table use timestamps?
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 16, 2016 at 15:28 | history | tweeted | twitter.com/StackProgrammer/status/776804977675268096 | ||
| Sep 16, 2016 at 12:53 | answer | added | Algy Taylor | timeline score: 1 | |
| Feb 3, 2014 at 10:16 | vote | accept | GWed | ||
| Jan 29, 2014 at 19:50 | answer | added | DougM | timeline score: 1 | |
| Jan 29, 2014 at 13:23 | comment | added | Robbie Dee | @PieterB There is definitely value in keeping history for some tables but I've never come across a case where you'd want to do this for every table - YMMV. | |
| Jan 29, 2014 at 12:49 | comment | added | Pieter B | Updating timestamps because there's a change smells to me. It would mean you would have only the time of the most recent change to a record, what you want in business is to have a history of all changes. | |
| Jan 29, 2014 at 12:11 | comment | added | Ross Patterson | You say Giving every table a timestamp is surely a great way to quickly bog down a database, but you don't say why. In almost every DBMS, a timestamp is a very small value - usually 8 bytes or less. Unless you add indices, that's negligible. | |
| Jan 29, 2014 at 12:02 | answer | added | JeffO | timeline score: 7 | |
| Jan 29, 2014 at 11:58 | history | edited | GWed | CC BY-SA 3.0 |
added 1 characters in body
|
| Jan 29, 2014 at 10:15 | answer | added | Robbie Dee | timeline score: 17 | |
| Jan 29, 2014 at 9:58 | answer | added | Leon Alexis Cardinal | timeline score: 5 | |
| Jan 29, 2014 at 9:55 | review | Close votes | |||
| Feb 3, 2014 at 3:03 | |||||
| Jan 29, 2014 at 9:42 | comment | added | thorsten müller | In practice I have timestamps on nearly every table (mostly for the reasons you mention). As far as I can say this has no negative effects on performance, at least for the type of databases that are commonly used in web development with maybe some 30.000 articles and hundreds of thousands of orders (which need timestamps anyway). There may be edge cases, but for example our ERP system (Microsoft Navision) hase those timestamps on most tables, too. | |
| Jan 29, 2014 at 9:41 | comment | added | Philipp | I think you already answered the question yourself. The only answer one can give is "It depends on the scenario". | |
| Jan 29, 2014 at 9:40 | history | edited | GWed |
edited tags
|
|
| Jan 29, 2014 at 9:33 | history | asked | GWed | CC BY-SA 3.0 |