On Feb 7, 2008 4:10 PM, Platonides Platonides@gmail.com wrote:
I sometimes find the options a bit limited. I may want to show only minor edits, or my non-minor edits. The query is not more complex, just changing some ANDs by ORs, or skipping the wiki defaults.
Actually, switching ANDs with ORs can have dramatic performance implications, at least in MySQL. (Before 5.0ish, ORed conditions can AFAIK never be satisfied by indexes, only by scanning values.) And too much flexibility can be a big problem too. Too much flexibility generally means you can't satisfy the conditions using B-trees, or at least MySQL can't, and so you have to scan rows. In particular, specifying a condition with fewer hits than the requested number of rows means scanning the entire table. (I guess that's a reason to not use the revision table for this!)