Re: Slow query performance

[Harrison Fisk]

Hi,

Is there a combined index on image (msj_nro,plz_id, via_id)? That is the only thing I see that will be useful for the query. The problem is that you are retrieving every row from menssage no matter what. That will cause MySQL to always do a full table scan. Without a WHERE or LIMIT or anything else similar, there isn't going to be much you can do, since it is going to return so much data.

Is there any reason why you are returning so much data? If you had a million rows in menssage, then the query would return at least one million rows, if not more.