Timeline for How to implement a 'default' flag that can only be set on a single row
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 19, 2011 at 12:12 | comment | added | onedaywhen | Thanks for clarifying. I must say if multiple users are frequently setting the sole default row then the design choice (flag column in the same table) is questionable. | |
| Oct 19, 2011 at 11:15 | comment | added | Jack Douglas | if multiple users are modifying simultaneously they will have to stand in line (serialize) - sometimes this is ok, often it is not (think heavy OLTP or long transactions). | |
| Oct 19, 2011 at 9:19 | comment | added | Jack Douglas | even if your RDBMS supports this, it will serialize like crazy so if you have more than one user, you may have a problem | |
| Oct 19, 2011 at 9:09 | history | answered | onedaywhen | CC BY-SA 3.0 |