dmwm / PHEDEX

CMS data-placement suite
8 stars 18 forks source link

Inefficient query by site name in Web Page Data::Subscriptions interface #1111

Open nataliaratnikova opened 6 years ago

nataliaratnikova commented 6 years ago

Issue reported in https://ggus.eu/index.php?mode=ticket_info&ticket_id=131073

By default query is using site name [1], which is too slow and often fails with an error. When replaced by the site ID [2], page returns results almost immediately.

[1] https://cmsweb.cern.ch/phedex/prod/Data::Subscriptions#state=create_since%3D0%3Bnode%3DT3_US_TAMU [2] https://cmsweb.cern.ch/phedex/prod/Data::Subscriptions#state=create_since%3D0%3Bnode%3D1441