I’m developing an application that might potentially store billions of records in a single set on our Aerospike cluster.
A very common use case will be fetching the top n most popular records from the DB.(We can expect such calls almost every second).
From what I understand, the only way to achieve this will be using some UDF that sorts by popularity and limits the result.
So, my question is what will be the impact on performance? Might this cause Aerospike to hang when sorting so many records repeatedly every few seconds? If yes, is there a better alternative available?