search

PMA-2020 / pma-api

The best way to programmatically access PMA2020 data.
http://api.pma2020.org
MIT License
1 stars 3 forks source link

Expensive operation using survey.code #58

Closed joeflack4 closed 5 years ago

joeflack4 commented 5 years ago

Description

Received the following warning from SqlAlchemy:

SAWarning: The IN-predicate on "survey.code" was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate.  Consider alternative strategies for improved performance.
  'strategies for improved performance.' % expr)

Additional details

Was running the test TestRoutes.test_routes().

joeflack4 commented 5 years ago

Fixed