List:Bugs« Previous MessageNext Message »
From:Thimble Smith Date:March 17 2000 4:26pm
Subject:Re: LIKE '%xxx%' much faster on BLOBs than on TEXTs (Win only)
View as plain text  
On Fri, Mar 17, 2000 at 04:21:27PM +0100, Florian Kusche wrote:
>Hello Jan,
>
>> A potential explanation is that the table with the TEXT field
>> on your NT system is severely fragmented.  This can occurr
>> e.g. if you add records by an insert, and then you update
>> the contents of the TEXT field.  Or if you had some deletes.
>
>I don't think so. I did the following:
>- CREATE TABLE
>- INSERT all data
>- do the select
>
>If I have TEXT-columns, it's slow and with BLOB columns it's fast.

I think the problem is that with TEXT columns the comparisons are
case insensitive, but with BLOB columns the comparisons can be
done byte by byte.

Tim
-- 
Tim Smith   < tim@stripped >  :MySQL Development Team:  Boone, NC  USA.
Thread
LIKE '%xxx%' much faster on BLOBs than on TEXTs (Win only)Florian Kusche17 Mar
  • Re: LIKE '%xxx%' much faster on BLOBs than on TEXTs (Win only)Jan Dvorak17 Mar
  • Re: LIKE '%xxx%' much faster on BLOBs than on TEXTs (Win only)Florian Kusche17 Mar
    • Re: LIKE '%xxx%' much faster on BLOBs than on TEXTs (Win only)Thimble Smith17 Mar
  • Re: LIKE '%xxx%' much faster on BLOBs than on TEXTs (Win only)Jan Dvorak21 Mar