Responses interspersed
James <[EMAIL PROTECTED]> wrote on 06/22/2005 04:48:59 PM:
> I did a little test by configure the `name` and `city` with FULLTEXT
> INDEX and a regular INDEX.
>
> mysql> describe testing_text_performance;
> +---+--+--+-+
I did a little test by configure the `name` and `city` with FULLTEXT
INDEX and a regular INDEX.
mysql> describe testing_text_performance;
+---+--+--+-+---++
| Field | Type | Null | Key | Default |
Extra
I have a table which includes the following columns in addition to
lots of other ones
name - populated with just one name
city - populated with just one city
keywords - lots of keywords
I'm definitely going to use a FULLTEXT on the `keywords` column
For `name` and `city` ...I will allow users
