Thanks.. the problem is I'm running MySQL 4.1.16 I might try FULLTEXT...
On 9/27/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > >
-- 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/[EMAIL PROTECTED]