| From: | Mirek Budzanowski <mirekb(at)tcs(dot)uni(dot)wroc(dot)pl> |
|---|---|
| To: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] How to Make Case InSensitive??? |
| Date: | 1998-09-21 19:07:05 |
| Message-ID: | 199809211907.VAA17602@hps.ii.uni.wroc.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> > I working with a table of about 70'000 records and I made 2 tests about
> > the optimisation of ~* :
> >
> > With ~* :
> > real 11.52 *
> > user 0.02
> > sys 0.01
> >
> > With upper(...) and like upper(%...%)
> > --------------------------------------
> > real 4.44 *
> > user 0.03
> > sys 0.00
> >
> > Relsult: it seem to be 2.6 time more optimised to use upper(...) like
> > upper('%...%') ???
> This is interesting. Does anyone have an idea why this is happening?
In my opinion the reason why regular expresion matching is sloer is
obvious. Regulars expresion are very powerfull, but the code that
does the matching is a bit more complicated. With like expresions
you may write simple and faster code.
Mirek
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1998-09-22 16:47:49 | Re: [SQL] How to Make Case InSensitive??? |
| Previous Message | Jackson, DeJuan | 1998-09-21 18:07:13 | RE: [SQL] To create the query for a select where one is NOT in th e other |