• Luke Duncalfe's avatar
    Fix timeouts on test webhooks · bc7b447c
    Luke Duncalfe authored
    The Issues, Merge Requests and Notes test webhooks were susceptible to
    timeouts due to the oldest records being selected to be in the test
    webhook payload.
    
    Indexes on these tables seem to favour sorting newest to oldest, the
    difference between selecting the oldest Issue, Merge Request, or Note vs
    the newest for `gitlab-org/gitlab` is ~ 25 seconds (or sometimes more)
    on `#database-lab` (which is slower than production, but indicative) vs
    ~10 milliseconds when selecting the newest records.
    
    Finders are now used for all scoping to make the scoping even safer.
    
    https://gitlab.com/gitlab-org/gitlab/-/issues/290116
    bc7b447c
integrations_test_webhook_optimizations.yml 284 Bytes