Thanks for taking the time to report this.

Numbers and exact steps (as there are several search interfaces) are welcome to allow reproducing.

Entering wikimedia-ro in the search field on the top right on this very page (which in my case defaulted to the scope of "Open tasks", see the dropdown in front of the search field) took 39 seconds here, bypassing the browser cache.

Using the global search at https://phabricator.wikimedia.org/search/query/advanced/ took 37 seconds, bypassing the browser cache.

Using https://phabricator.wikimedia.org/maniphest/query/advanced/ and searching for "Contains Words = wikimedia-ro" (query URL: https://phabricator.wikimedia.org/maniphest/query/cLHE_cemD1dG/#R ) and bypassing the browser cache took 69 seconds here

Thanks for confirming that searches are taking a very long time.

It seems to me that search results should appear in about 3 seconds max, not 37 to 69 seconds. What are the next steps to get this situation addressed? Thanks.

From the top of my head:

• Anyone could add recommendations to use more specialized search queries (e.g. search by product / using a narrower scope in the dropdown) in our Phabricator documentation.
• Engineering-wise, I'm not aware of Release Engineering having resources to investigate currently (but I'm happy to be corrected).
• Phabricator Performance debugging documentation.
• List of other performance-related Wikimedia Phabricator tasks

I believe you may have hit myisam limit, we switched to innodb and when I search now it take a few secs more then normal but not 20 or 30 secs.

Is this fixed for you?

It works for me.

Your welcome

For the records, T146910 covers the myisam / innodb topic