slow query when column type is text / longtext

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
KW
Posts: 125
Joined: Tue 19 Feb 2008 19:12

slow query when column type is text / longtext

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
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

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".

Post Reply