We broadly want to get rid of views, and calculating rank every time
will require careful index analysis to ensure that the query can be
answered from indices.
If it can't be it will scale poorly; I think long term we really
shouldn't be indexing on the fly.
We broadly want to get rid of views, and calculating rank every time
will require careful index analysis to ensure that the query can be
answered from indices.
If it can't be it will scale poorly; I think long term we really
shouldn't be indexing on the fly.