MySQL Forums
Forum List  »  Performance

slow queries and blob fields
Posted by: Erin ONeill
Date: July 06, 2005 11:09AM

Is it possible for a query that calls a blob to ever NOT be in the slow_query_log?

I have a slow query that calls 1483 rows (I'm gonna speak to my programmer about them needing 1483 rows!) one of the fields is a longtext. I've already asked that it be moved to a text. When I run an explain on the simpliest of queries against this table I get this:

explain SELECT * FROM news WHERE active = 'yes' AND news_date <= 1120337337 ORDER BY news_date DESC;
+-------+------+------------------+--------+---------+-------+------+-----------------------------+
| table | type | possible_keys | key | key_len | ref | rows | Extra |
+-------+------+------------------+--------+---------+-------+------+-----------------------------+
| news | ref | active,news_date | active | 35 | const | 1483 | Using where; Using filesort |
+-------+------+------------------+--------+---------+-------+------+-----------------------------+

the key = active (which should be changed to an enum which I'm working on). But using filesort !

Both active and news_date do have indexes on them. Any suggestions? This table has a lot of both reads and writes....

erin

Options: ReplyQuote


Subject
Views
Written By
Posted
slow queries and blob fields
2677
July 06, 2005 11:09AM
1736
July 06, 2005 11:59AM
1650
July 06, 2005 06:05PM
1906
July 07, 2005 03:32PM
1651
July 07, 2005 05:58PM
1756
July 12, 2005 10:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.