Chris, I notice a couple things from the first explain: it looks like you have a superpage size of 10k, rather than the more common 1k or 2.5k; it looks like you've forced a search with no terms, just a sort by pubdate for all "book-ish" things. The latter is the main reason for the slowness, though the sort doesn't help it go faster.
With the new attribute infrastructure, we have the ability to build smarter "show everything" listings (rather than using the full power of QP-based search), so I think there's an opportunity for a more traditional (in the library sense) "index listing" API which would be fairly simple (comparatively) when there are no user-provided search terms, just filters and the like.
Chris, I notice a couple things from the first explain: it looks like you have a superpage size of 10k, rather than the more common 1k or 2.5k; it looks like you've forced a search with no terms, just a sort by pubdate for all "book-ish" things. The latter is the main reason for the slowness, though the sort doesn't help it go faster.
With the new attribute infrastructure, we have the ability to build smarter "show everything" listings (rather than using the full power of QP-based search), so I think there's an opportunity for a more traditional (in the library sense) "index listing" API which would be fairly simple (comparatively) when there are no user-provided search terms, just filters and the like.