I am new to Yii and RBAC as well, I found that the Yii RBAC database table name AuthAssignment, have the userid column as varchar.
Will there be any performance issue when the number of users in the web application reach over thousand and more? As far as I realize string comparison in database is far more slow then integer. Every time the RBAC check for access privilege, the code need to search from the database table using string(varchar) comparison.
Yii is designed to be like this, must has his own reason, any expert here has advice to me why?
I try to use Yii's RBAC for my web apps, which possible can reach >100K of members, I am concerning about the performance…