Page 1 of 1

slow query when column type is text / longtext

Posted: Wed 29 Apr 2009 00:13
by KW
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.

Posted: Tue 05 May 2009 13:24
by Shalex
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".