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
In MySQL 5.0.3 and later, you can create VARCHAR columns of up to
65,535 character lengths:
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.
On 9/27/06, Peter Van Dijck <petervandijck@stripped> wrote:
> 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?
> 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