slow query when column type is text / longtext

slow query when column type is text / longtext

Postby 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.
KW
 
Posts: 116
Joined: Tue 19 Feb 2008 19:12

Postby 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".
Shalex
Devart Team
 
Posts: 7305
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL