MySQL Forums
Forum List  »  Performance

Re: Slow query performance
Posted by: Harrison Fisk
Date: October 15, 2004 11:28AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3376
October 15, 2004 06:06AM
Re: Slow query performance
2343
October 15, 2004 11:28AM


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.