add years to pagination (tricky one, maybe impossible?)

[joe_g]

Hey experts,

I had this cool idea I would love to implement, but so far I didn't manage to do it with good enough performance. I've got some date fields on a page, and I'd like to have years indicate on the pagination pages, like so:

What I tried is to read all the results, read all the years for each results, then slice them up in pages. This is way to slow, obviously.

Only thing i could think of is to make a nightly batch job that calculates the pagination, but it starts to get a bit messy and could easily be out of sync.

This is no life-and-death situation, it's just something I would like to do. If you have any ideas how to solve this I'm curious to hear it.