Improve perf for long WMO list search with ArgoIndex

[gmaze]

The modular method for search in ArgoIndex pyarrow and pandas backends is not an optimal design for large requests.

For instance the search_wmo methods:

• argopy/argopy/stores/argo_index_pd.py

  Line 234 in 208b9e8

  def search_wmo(self, WMOs, nrows=None):

• argopy/argopy/stores/argo_index_pa.py

  Line 289 in 208b9e8

  def search_wmo(self, WMOs, nrows=None):

are based on a simple loop through the list of WMOs to search.
This could be optimised with apply methods for instance. But, in this cas could we keep the module design as it is ? (with a the construction of a binary mask that is then applied by the run method).

[github-actions]

This issue was marked as staled automatically because it has not seen any activity in 90 days