On Fri, 19 Oct 2007 18:19:55 -0500 Michael Glaesemann <grzm@xxxxxxxxxxxxxxx> wrote: > > On Oct 19, 2007, at 16:03 , Josh Trutwin wrote: > > > SELECT * FROM table WHERE foo="bar" ORDER BY abc LIMIT x OFFSET y; > > The server will have to generate at most OFFSET + LIMIT rows, > returning LIMIT rows or fewer. > > > SELECT * FROM table WHERE foo="bar" ORDER BY abc; > > This will return all of the rows available. > > Unless you're going to be returning all of the rows where > foo="bar" (e.g., executing multiple LIMIT OFFSET queries) in one > request, I should think the first query would be more performant: > fewer rows for the server to process (in the final step at least) > and less data transmitted between the server and your application. Thanks - server and application are on the same box so not as big a concern, but this is the way I decided to go for the time being. Josh ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
