question

xindazeng avatar image
xindazeng asked

Get a list of random players based on custom filters

We are developing a custom async matchmaking system and we are interested in getting a list of random players based on some custom filters. Right now we are storing some player info in player publisher data with multiple fields combined into one JSON string (e.g., player speciality, geolocation, etc.). Are there ways that we can efficiently filter players based on specific queries, say, get a random list of players whose geolocation is NA?

Player Datamultiplayer
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Citrus Yan avatar image
Citrus Yan answered

Currently we don’t support querying players based on their custom filters. For your case I think a efficient way would be hosting a lookup table of player info in external databases such as Redis cache: https://azure.microsoft.com/en-us/services/cache/#features where you can perform high performance & reliable queries from.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Error rendering WebPanel (widgets/consolidation-widget.ftl): org.hibernate.hql.internal.ast.QuerySyntaxException: AvailableConsolidation is not mapped [from AvailableConsolidation up where up.node = :node]