Timeline for Handling deleted users - separate or same table?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 21, 2011 at 9:44 | comment | added | Péter Török | @Aaronaught, OK, I phrased it wrong. The DBMS can do the work for you, but it is still extra work (because the row must be physically moved from one location to another, possibly to a different file), and it may deteriorate the physical distribution of data. | |
| Jul 21, 2011 at 2:44 | comment | added | Aaronaught | @Péter: Huh? You can partition on any criteria you want, including the deleted flag. | |
| Jul 20, 2011 at 12:42 | comment | added | Péter Török | Then you must move rows from one partition to another when deleting users, which is definitely not how partitions are intended to be used. | |
| Jul 20, 2011 at 11:29 | history | answered | mczajk | CC BY-SA 3.0 |