From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | ZeugswetterA(at)spardat(dot)at |
Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us, pgman(at)candle(dot)pha(dot)pa(dot)us, phede-ml(at)islande(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Unicode combining characters |
Date: | 2001-10-03 09:30:01 |
Message-ID: | 20011003183001R.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
> I don't think your search string is sufficient for a test.
> With 'aaa' it actually knows that it only needs to look at the
> first three characters of a. Imho you need to try something
> like liketest(a,'%aaa%').
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...
MB+LIKE
Total runtime: 1321.58 msec
Total runtime: 1718.03 msec
Total runtime: 2519.97 msec
Total runtime: 4187.05 msec
Total runtime: 7629.24 msec
Total runtime: 14456.45 msec
Total runtime: 17320.14 msec
Total runtime: 17323.65 msec
Total runtime: 17321.51 msec
noMB+LIKE
Total runtime: 964.90 msec
Total runtime: 993.09 msec
Total runtime: 1057.40 msec
Total runtime: 1192.68 msec
Total runtime: 1494.59 msec
Total runtime: 2078.75 msec
Total runtime: 2328.77 msec
Total runtime: 2326.38 msec
Total runtime: 2330.53 msec
--
Tatsuo Ishii
From | Date | Subject | |
---|---|---|---|
Next Message | Lee Kindness | 2001-10-03 10:01:30 | Re: Bulkloading using COPY - ignore duplicates? |
Previous Message | Michael Meskes | 2001-10-03 09:29:18 | Re: My last ECPG commit |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-10-03 13:00:13 | Re: Simplified Chinese translation file for nls support |
Previous Message | Zeugswetter Andreas SB SD | 2001-10-03 08:09:46 | Re: Unicode combining characters |