On Thu, Mar 17, 2011 at 7:56 PM, OQ overlordq@gmail.com wrote:
No, no they shouldn't. Being an autoincrement field you shouldn't be using rev_id like that.
Why not? Some kind of tie-breaker is needed when ordering, if you want the order to be well-defined (which is needed for, e.g., IndexPager in MediaWiki). rev_id is as good a tie-breaker as any. It's unique and short, to start with. Also, for InnoDB, it has the advantage of being stored in the leaf of every index, so you might be able to avoid data lookups in some cases.