From: | nolan(at)celery(dot)tssi(dot)com |
---|---|
To: | pgman(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian) |
Cc: | pgsql-general(at)postgresql(dot)org (pgsql general list) |
Subject: | MySQL/PG search times |
Date: | 2003-06-23 18:11:19 |
Message-ID: | 20030623181119.942.qmail@celery.tssi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-docs pgsql-general |
> We require ~* syntax for that, or upper()/lower().
Slowly the light dawns!
If I anchor a ~ search on both ends, it is the same search as =.
Duh!
I converted the prototype over to use ~ and it is running much faster.
I'll try to do some detailed timings against MySQL tonight.
--
Mike Nolan
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-06-23 18:32:38 | Re: MySQL/PG search times |
Previous Message | Dennis Gearon | 2003-06-23 18:07:41 | Re: [GENERAL] interesting PHP/MySQL thread |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-06-23 18:32:38 | Re: MySQL/PG search times |
Previous Message | Dennis Gearon | 2003-06-23 18:07:41 | Re: [GENERAL] interesting PHP/MySQL thread |
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Lane | 2003-06-23 18:11:27 | Re: SELECT @@IDENTITY |
Previous Message | Dennis Gearon | 2003-06-23 18:10:19 | Re: A creepy story about dates. How to prevent it? |