Skip to content
Snippets Groups Projects
  • David Ormsbee's avatar
    Modify forum roles query for Aurora performance. · ebbd2627
    David Ormsbee authored
    This is a fix for the performance issues in EDUCATOR-3374
    
    AWS's Aurora backend for MySQL selects the wrong index on the
    django_comment_client_role_users table, leading to performance issues.
    This commit replaces that join with individual requests for permissions
    for each role (of which there may be several for any given user).
    It's dumber SQL, but Aurora will do the right thing.
    ebbd2627