> Bruce Momjian <[EMAIL PROTECTED]> writes: > > If no one can find a case where multibyte is slower, I think we should > > enable it by default. Comments? > > Well, he just did point out such a case: > > >> no MB with MB > >> LIKE 0.09 msec 0.08 msec > >> REGEX 0.09 msec 0.10 msec > > But I agree with your conclusion. If the worst penalty we can find is > that a regex comparison operator is 10% slower, we may as well turn it > on by default. Most people will never notice the difference, and anyone > who really cares can always turn it off again.
But the strange thing is that LIKE is faster, perhaps meaning his measurements can't even see the difference, or is it because the LIKE optimization is off for multibyte. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly