Hi Aaron, > > Aaron: more returned rows make a real difference if the imapd and > > database are on different hosts. > > True, but how much of a difference? The REGEXP I wrote took almost 10 > minutes to do what my LIKE did in 30 seconds. Unless your two hosts are > separated by 300 feet of 802.11 at 2 mbits, I don't see this as an issue.
If the query difference is that large you are right of course. > > The point I don't see in this discussion is: where is the problem using > > the is_header column even if that requires running a script or > > program in the 2.0 series? The database structure stays the same, people > > don't need to change any software, they can switch between old and new > > dbmail of 2.0 series so it won't hurt but we gain a lot. > > If we started to rely on is_header in 2.0.1, then if someone downgraded to > 2.0.0 for a while, then upgraded again, they would have to re-run the > upgrade script to assign the missing is_header columns. I'm concerned that > this eats into our robustness along a stable series. Hm right. But because of that rare case everyone gets a (much) slower 2.0.1 ? If 2.0.1 is stable no one will go back to 2.0 :-) Thomas -- http://www.tmueller.com for pgp key (95702B3B)
