« Previous | Next » 

Revision 97341ccb


Added by Georgios D. Tsoukalas over 11 years ago

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)


  • added
  • modified
  • copied
  • renamed
  • deleted

View differences