• Yorick Peterse's avatar
    Refactor getting user groups/projects/contributions · 5fcd9986
    Yorick Peterse authored
    This new setup no longer loads any IDs into memory using "pluck",
    instead using SQL UNIONs to merge the various datasets together. This
    results in greatly improved query performance as well as a reduction of
    memory usage.
    
    The old setup was in particular problematic when requesting the
    authorized projects _including_ public/internal projects as this would
    result in roughly 65000 project IDs being loaded into memory. These IDs
    would in turn be passed to other queries.
    5fcd9986
user.rb 24.5 KB