Hello
I might be overlooking something obvious here, but how is it possible to check for a value in one of 2 properties?
Lets say you store chat histories between two users with userid1 and userid2 and do so in a table whichs element contains these assigned to properties id1 and id2, how can I list all objects in the database where either id1 = userid1 OR id2 = userid1 to optimize the data?
I ask because it otherwise seems to be pretty complex to request both in a performant and low latency form (loadrange request within a loadrange request and then combining the processed results)
Additionally it seems that even server side bigdb causes webservice traffic and that generates about 80 times the amount of data we do on the client communication (20kb vs 1.6mb and that for basically nothing but a few messages in history being sent around - all listed under multiplayer which puzzles me anyway as clients can not request anything from bigdb), so I logically want to limit the data sent to the data I actually want, not a big blob of irrelevant data that I need to LINQ filter afterwards on the server, thats double-unfavorable for the player.io backend
EDIT: Edited the subject to be more appropriate