> > Ok. I ran the modified test (now the iteration is reduced to 100000 in > > liketest()). As you can see, there's huge difference. MB seems up to > > ~8 times slower:-< There seems some problems existing in the > > implementation. Considering REGEX is not so slow, maybe we should > > employ the same design as REGEX. i.e. using wide charcters, not > > multibyte streams...
Let me add I think our regex code is very slow. It is the standard BSD regex library by Henry Spencer. He rewrote it a few years ago for TCL 8.X and said he was working on a standalone library version. I have asked him several times via email over the years but he still has not released a standalone version of the new optimized regex code. It is on our TODO list. -- 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 6: Have you searched our list archives? http://archives.postgresql.org