I have a 3rd party app that I suspect is behaving badly (actually, I'm about 99.9% sure it is). When I save changes to the database, it executes what should be (as near as I can tell) about 20 SQL ...

I'm trying to re-order a bunch of rows based upon user preference. For example I have 10 row. There is a column called order_id that gives each row an id from 1-10. I want to be able to do things like ...