launchpad-dev team mailing list archive

[Robert Collins <robertc@xxxxxxxxxxxxxxxxx>]

You could use a list (e.g. rather than sequence, have a next pointer
pointing at the id of the next WI; you'd only need to update 2 rows to
do an in-middle insert.

OTOH updating a dozen is one sql statement (done carefully) and will be fast.

KISS IMO.

-Rob