Skip to content

Speed up ee/spec/requests/api/search_spec.rb

Igor Drozdov requested to merge id-speed-up-search-api-spec into master

What does this MR do?

Before

Total events: 63065

Finished in 15 minutes 8 seconds (files took 1 minute 6.62 seconds to load)
339 examples, 0 failures

[TEST PROF INFO] Factories usage

 Total: 2569
 Total top-level: 1655
 Total time: 221.1864s
 Total uniq factories: 18

   total   top-level     total time      time per call      top-level time               name

     525         525        6.3466s            0.0121s             6.3466s personal_access_token
     475          67       21.7870s            0.0459s             3.1182s               user
     434         392      106.0420s            0.2443s            99.2846s            project
     434           0       22.9324s            0.0528s             0.0000s          namespace
     126         108       25.1402s            0.1995s            18.4736s      merge_request
     108         108        2.3219s            0.0215s             2.3219s          milestone
     103         103        2.3263s            0.0226s             2.3263s elasticsearch_indexed_namespace
      92          92        5.1782s            0.0563s             5.1782s          wiki_page
      84          84        4.5305s            0.0539s             4.5305s              issue
      50          50        2.6298s            0.0526s             2.6298s       project_wiki
      46          46       63.3828s            1.3779s            63.3828s elasticsearch_indexed_project
      30          30        5.1801s            0.1727s             5.1801s              label
      18          18        7.0908s            0.3939s             7.0908s note_on_merge_request
      18          18        0.3538s            0.0197s             0.3538s               note
      12          12        0.9361s            0.0780s             0.9361s            snippet
      12           0        0.6178s            0.0515s             0.0000s             author
       1           1        0.0263s            0.0263s             0.0263s              group
       1           1        0.0069s            0.0069s             0.0069s            license

After

Total events: 29112

Finished in 7 minutes 8 seconds (files took 1 minute 5.16 seconds to load)
153 examples, 0 failures

[TEST PROF INFO] Factories usage

 Total: 1099
 Total top-level: 871
 Total time: 99.2698s
 Total uniq factories: 18

   total   top-level     total time      time per call      top-level time               name

     295         295        3.5764s            0.0121s             3.5764s personal_access_token
     238         208       44.6426s            0.1876s            41.1823s            project
     219          31       10.7547s            0.0491s             1.4756s               user
      72          72        1.4661s            0.0204s             1.4661s          milestone
      66          60       11.7069s            0.1774s             9.6173s      merge_request
      60          60        3.4584s            0.0576s             3.4584s              issue
      47          47        0.8630s            0.0184s             0.8630s elasticsearch_indexed_namespace
      26          26        1.3274s            0.0511s             1.3274s          wiki_page
      21          21       30.5042s            1.4526s            30.5042s elasticsearch_indexed_project
      18          18        2.1647s            0.1203s             2.1647s              label
      14          14        0.6221s            0.0444s             0.6221s       project_wiki
       6           6        2.2343s            0.3724s             2.2343s note_on_merge_request
       6           6        0.1257s            0.0209s             0.1257s               note
       4           4        0.5093s            0.1273s             0.5093s            snippet
       4           0        0.3367s            0.0842s             0.0000s             author
       1           1        0.0731s            0.0731s             0.0731s          namespace
       1           1        0.0183s            0.0183s             0.0183s            license
       1           1        0.0515s            0.0515s             0.0515s              group

Minutes saved: 8 minutes

Queries saved: 33953

Edited by Igor Drozdov

Merge request reports