Revision 97341ccb
ID | 97341ccba796fba96054a47823392dcd22e43e96 |
Fix serious inefficiency in pithos 0.13 migration
As was run on production during migration.
The migration looped over all rows (node, muser) from versions,
and update muser in each one.
However, the tuples (node, muser) are not unique in the table,
and more important, the muser values are much fewer than the nodes
(since there are by definition much more users than files).
Instead, we now loop over the distinct muser values,
and issue an update statement for each one (which updates much more
than one row, one for every version this muser has produced)
Files
- added
- modified
- copied
- renamed
- deleted