Re: Query performance on database with joins

[jools smyth]

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.