slow query when column type is text / longtext

KW · Post by KW » Wed 29 Apr 2009 00:13

http://screencast.com/t/oLkcoVMk

Here is a screen cast.

Basically, query is slow when I include a column in the query.

Let me know if you can help me out in order to debug the situation.

Shalex · Post by **Shalex** » Tue 05 May 2009 13:24

This is a designed behaviour. Probably, your HTML column contains a big amount of data. MySQL server doesn't allow to make deffered fetch of text/blob fields, data is retrieved entirely when you perform "Execute Query".