tedster - 9:50 am on Jul 12, 2008 (gmt 0)

I'd say the key is that paginated result sets cannot be the only click path to your deep product pages - not if you want them to rank, even for long tail searches. In addition to the technical challenge of getting those unique titles and descriptions, there's no way enough PageRank is going to circulate down into that pit.

So in cases like this, I try to be creative and consider how else a user might be served in navigating to the individual product pages. Database result sets alone are rather lame. They may be easy to generate, but they're not very effective beyond the top few pages.