I have a simple table with some fields, one of theme is a mediumblob field.
about 422 Mb.
I just want to do a simple query like this
ORDER BY field1 DESC;
This query need 20 seconds to be done!
If I avoid condition AND “Order By” or if I use a LIMIT 0,1, than the query take almost 1 sec, but I really need to select more than 1 record and use condition, order by and also join it with another table.
How can be optimized this simply query?!