List:General Discussion« Previous MessageNext Message »
From:Dan Buettner Date:September 28 2006 2:08am
Subject:Re: where url = 'x' with url a TEXT field
View as plain text  
You can create FULLTEXT indexes on text fields - but that may not be
the best solution for your situation since you are querying for an
exact match.

In MySQL 5.0.3 and later, you can create VARCHAR columns of up to
65,535 character lengths:
http://dev.mysql.com/doc/refman/5.0/en/char.html

I seem to recall you were asking about storing URLs up to the
practical limit, 2083 characters.  I've never used a varchar column
that long before; I'm not sure what the performance implications might
be, or how effective a database index on a field that length would be.

Still, worth a try.  Could be that it will work smashingly.

HTH,
Dan

On 9/27/06, Peter Van Dijck <petervandijck@stripped> wrote:
> Hi,
> since urls can be longer than 255 chars, I made the url field a TEXT field.
>
> The problem is, I can't make an index on it, so doing 'WHERE
> url='xxx'' becomes a very sloow query.
>
> Any ideas for solutions? Am I mistaken in the idea that I can't make
> an index on a TEXT field?
>
> Thanks!
> Peter
>
> --
> Find 10000s of videoblogs and podcasts at http://mefeedia.com
> my blog: http://poorbuthappy.com/ease/
> my job: http://petervandijck.net
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
Thread
where url = 'x' with url a TEXT fieldPeter Van Dijck28 Sep
  • Re: where url = 'x' with url a TEXT fieldDouglas Sims28 Sep
  • Re: where url = 'x' with url a TEXT fieldDan Buettner28 Sep
    • Re: where url = 'x' with url a TEXT fieldPeter Van Dijck28 Sep
  • Re: where url = 'x' with url a TEXT fieldCBTS) GEAE28 Sep