Performance slow if model is Tree and many define

[yvladimirov]

Hi guys we decided to use FGA and we have problem with Performance

version: 1.8.4
storage: Postgresql

schema

type user

type organization
  relations
    define global: [organization]
    define super_admin: [user]
    define super_viewer: [user]

    define admin: [user] or super_admin from global
    define editor: [user] or admin
    define viewer: [user] or editor or super_viewer from global
    define member: [user] or viewer or editor or admin
type advertiser
  relations
    define parent: [organization]
    define direct_admin: [user] and member from parent
    define direct_editor: [user] and member from parent
    define direct_viewer: [user] and member from parent

    define admin: direct_admin or admin from parent
    define editor: direct_editor or admin or editor from parent or some_agency_editor
    define viewer: direct_viewer or editor or admin or viewer from parent or some_agency_viewer
    define member: viewer or editor or admin or member from parent
type campaign
  relations
    define parent: [advertiser]
    define direct_admin: ([user] and member from parent)
    define direct_editor: ([user] and member from parent)
    define direct_viewer: ([user] and member from parent)

    define admin: direct_admin or admin from parent
    define editor: direct_editor or admin or editor from parent
    define viewer: direct_viewer or editor or viewer from parent
    define member: viewer or editor or admin or member from parent

if we testing with dataset local is fast, but in production is very slow

request
fga query check --store-id=01JMENPWCCZZVHP3EF08ZEFXJQ user:000ea99f-23cc-4cfd-b2b7-1ceb3ce652de member campaign:10763
response
{"level":"info","timestamp":1739828761.164925,"msg":"grpc_req_complete","build.version":"v1.8.4","build.commit":"dc1a4803b1ae2f539a67cfa78a929923642c631b","grpc_service":"openfga.v1.OpenFGAService","grpc_method":"Check","grpc_type":"unary","user_agent":"openfga-sdk java/0.7.1","raw_request":{"store_id":"01JMENPWCCZZVHP3EF08ZEFXJQ","tuple_key":{"user":"user:000ea99f-23cc-4cfd-b2b7-1ceb3ce652de","relation":"member","object":"campaign:10763"},"contextual_tuples":null,"authorization_model_id":"01JJP9QG4FNDNF9RF6DWHPK3DA","trace":false,"context":null,"consistency":"UNSPECIFIED"},"raw_response":{"allowed":true,"resolution":""},"query_duration_ms":"636","request_id":"4a9208f7-19dc-4d95-9444-56bd24fb57c5","store_id":"01G5JAVJ41T49E9TT3SKVS7X1J","authorization_model_id":"01JJP9QG4FNDNF9RF6DWHPK3DA","datastore_query_count":517,"dispatch_count":69,"peer.address":"127.0.0.1:60996","grpc_code":0}

problem with many request to datastore datastore_query_count=517
Cache don't help, all request very fast but multiply by quantity....

We understand a problem with the model - large number of parents and recursive checks, maybe you can help me?