10k+ rule using ABAC takes about 500ms

[Castle1984]

I'm using ABAC model with casbin_sqlalchemy_adapter and there is about 10k+ rules.

Some rules in Mysql :

For example, The value of 't' calculated from this code,
time_start = time.time() result = enforce_mysql.enforce(sub, obj, act) t = (time.time()-time_start)*1000 ,
indicates that one check takes approximately 500ms+.
This differs significantly from the time shown in the benchmark for RABC.

Also, I have tried Fastbin,
such as enforce_fast_mysql = casbin.FastEnforcer('model.conf', adapter_mysql),
but it didn't improve a lot.

Is it my way of testing that is wrong?
Do you have any improvement methods to help me achieve the speed of RABC (large) in the benchmark? Thanks a lot.

[casbin-bot]

@techoner @Nekotoxin

[Castle1984]

As of now, after giving it some thought, I believe I can avoid this issue by implementing a compression strategy. I think I won't encounter a problem with such a large number of rules in the near future.
Also, this prolem has been posed in advice on performance