Skip to content
  • Kevin Falcone's avatar
    Every time Queue::HasRight was checked, we loaded Queues from the DB · 1f5fb2a9
    Kevin Falcone authored
    Since a lot of RTIR code checks Queue::HasRight (particularly on CF right
    checks) this was a ton of DB fetches to go get all the Constituency
    Queues.  Just having the Constituency CF caused the queries, even if
    there were no Queues to find.
    
    This was especially apparent in the REST interface where merely listing
    open Incident Reports caused thousands of SELECT main.* from Queues
    where Name like 'Incidents - %';
    1f5fb2a9