On Fri, Mar 17, 2000 at 04:21:27PM +0100, Florian Kusche wrote:
>> 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 Smith < tim@stripped > :MySQL Development Team: Boone, NC USA.