Skip to content

Optimize long query from How_to_query_DESI_DR1_Data.ipynb #270

Open
@stephjuneau

Description

@stephjuneau

In the notebook 04_HowTos/QueryClient/How_to_query_DESI_DR1_Data.ipynb there is a long query with a warning: "WARNING: This query will take several minutes, please be patient." which I saw took about ~4min 20sec for the rendered notebook version but I only got timeouts at 10 minutes during my three attempts: (1) Last night with DESI 25.3, (2) this morning with DESI 25.3, (3) this morning with DESI 23.1

I think there are at least two possible solutions:

  • Modify the query to use the LASTNIGHT column from, e.g., the ztile or tile table (my suggestion from before DR1 but we were too tight in time to try it)
  • Change to an Asynchronous query to avoid timeout issue

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions