MySQL Forums
Forum List  »  Newbie

Re: Query performance on database with joins
Posted by: jools smyth
Date: December 24, 2008 06:45PM

I appreciate your answers. Makes it a lot clearer.

My database is generated/updated on a daily basis and for these queries is read only. Because of this I can construct the data in different ways. It would be possible for me to include the authors/formats in the main table. Would this be faster. Any other tips I could use to speed it up?

I guess I could use a full text index instead of like. Any workarounds for the order by and limit (used for pagination)? I pre-order the data to a certain sort which works in the first case. After some testing I do see that the second case can be slower, so overall the first case is probably better.

Options: ReplyQuote

Written By
Re: Query performance on database with joins
December 24, 2008 06:45PM

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.