Additional result metrics on leaderboards are not sortable

[chrisvanrun]

I would be quite curious to explore the results in ranking on these.

[jmsmkn]

Unfortunately this is a difficult problem to solve. The sorting is done in the db, there are too many entries to do this in the Django world or on the client side. We only index the main metric, not the others. I cannot see a way to do this that avoids having custom indices on the json object (which is pretty much unique per challenge) or a plethora of extra fields on the model. Do you have any other ideas?

[pkcakeout]

Stored functions in the db? :shudder:

But it is a solution that should be easy to implement at least!

[chrisvanrun]

Unfortunately this is a difficult problem to solve. The sorting is done in the db, there are too many entries to do this in the Django world or on the client side. We only index the main metric, not the others. I cannot see a way to do this that avoids having custom indices on the json object (which is pretty much unique per challenge) or a plethora of extra fields on the model. Do you have any other ideas?

I was afraid of that complication after first seeing it not being possible. The cost of user variability I guess. If you cannot readily think of a way to do this, I don't think I can readily suggest anything.

[jmsmkn]

I'm going to close this, would be nice to have but I cannot think of a straightforward way to do it.