Re: [PERFORM] Inefficient max query when using group by

2017-05-04 Thread David Rowley
On 4 May 2017 at 22:52, wrote: > I have a performance problem with my query. As a simplified example, I have > a table called Book, which has three columns: id, released (timestamp) and > author_id. I have a need to search for the latest books released by multiple >

Re: [PERFORM] Inefficient max query when using group by

2017-05-04 Thread bricklen
On Thu, May 4, 2017 at 3:52 AM, wrote: > Hi, > > I have a performance problem with my query. As a simplified example, I > have a table called Book, which has three columns: id, released (timestamp) > and author_id. I have a need to search for the latest books released

[PERFORM] Inefficient max query when using group by

2017-05-04 Thread jesse.hietanen
Hi, I have a performance problem with my query. As a simplified example, I have a table called Book, which has three columns: id, released (timestamp) and author_id. I have a need to search for the latest books released by multiple authors, at a specific point in the history. This could be