MySQL/PG search times

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

In response to

Responses

Browse pgsql-advocacy by date

  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

Browse pgsql-docs by date

  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

Browse pgsql-general by date

  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?