Re: [GENERAL] interesting PHP/MySQL thread

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <nolan(at)celery(dot)tssi(dot)com>, "The Hermit Hacker" <scrappy(at)postgresql(dot)org>
Cc: "The Hermit Hacker" <scrappy(at)postgresql(dot)org>, "Jan Wieck" <JanWieck(at)Yahoo(dot)com>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Josh Berkus" <josh(at)agliodbs(dot)com>, "Joe Conway" <mail(at)joeconway(dot)com>, "\"\"\"Advocacy PostgreSQL\"\"\"" <pgsql-advocacy(at)postgresql(dot)org>, "PostgreSQL-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Date: 2003-06-23 05:54:07
Message-ID: 029201c3394b$dc63e310$2800a8c0@mars
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-docs pgsql-general

> Also, unlike PostgreSQL (at least in 7.3), if you define an index on
> the column, mysql appears to use it for LIKE queries.
>
> "SELECT * FROM table WHERE field LIKE 'nolan%';"

Nonsense. PostgreSQL indexes such a thing quite happily. I've used that a
lot.

> is very fast in mysql but not in 7.3, and even non-anchored LIKE searches
> in mysql appear to be using the index.
>
> "SELECT * FROM table WHERE field LIKE '%nolan%';"
>
> executes considerably faster with an index on field than without one.

Hmmm - that seems iffy to me - have they invented a new field of index
theory?

Chris

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Michael Meskes 2003-06-23 06:30:41 Re: [pgsql-advocacy] MySQL gets $19.5 MM
Previous Message Sean Chittenden 2003-06-23 05:44:45 Re: [GENERAL] interesting PHP/MySQL thread

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2003-06-23 06:16:05 Re: [PATCHES] Synopsis inconsistencies
Previous Message Sean Chittenden 2003-06-23 05:44:45 Re: [GENERAL] interesting PHP/MySQL thread

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-06-23 05:59:04 Re: Thousands of semops for every i/o
Previous Message Sean Chittenden 2003-06-23 05:44:45 Re: [GENERAL] interesting PHP/MySQL thread