Speed up ee/spec/requests/api/search_spec.rb
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