home / github

Menu
  • GraphQL API
  • Search all tables

issue_comments

Table actions
  • GraphQL API for issue_comments

4 rows where issue = 931016490 and user = 14371165 sorted by updated_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updated_at (date)

user 1

  • Illviljan · 4 ✖

issue 1

  • Do not transpose 1d arrays during interpolation · 4 ✖

author_association 1

  • MEMBER 4
id html_url issue_url node_id user created_at updated_at ▲ author_association body reactions performed_via_github_app issue
886450425 https://github.com/pydata/xarray/pull/5542#issuecomment-886450425 https://api.github.com/repos/pydata/xarray/issues/5542 IC_kwDOAMm_X8401ij5 Illviljan 14371165 2021-07-26T07:28:58Z 2021-07-26T07:33:57Z MEMBER

It probably is decently fast but it can't compare to just not running the .copy() code if a copy isn't necessary. :) But this isn't a major bottleneck either:

Before, the transpose is one of the largest bottlenecks in missing.interp where the .copy() is what takes time. missing.interp took 1.33s to run.

After, the transpose obviously isn't a factor anymore since it isn't triggered. missing.interp took 1.24s to run.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Do not transpose 1d arrays during interpolation 931016490
886261206 https://github.com/pydata/xarray/pull/5542#issuecomment-886261206 https://api.github.com/repos/pydata/xarray/issues/5542 IC_kwDOAMm_X84000XW Illviljan 14371165 2021-07-25T21:38:49Z 2021-07-25T21:38:49Z MEMBER

Edit: actually is this already implemented? https://github.com/pydata/xarray/blob/main/xarray/core/variable.py#L1441-L1444. Does interpolate not hit this code path?

Yes, that's the copy that's slow and there's no real need to create a new copy in the 1D case. My (bad) idea was to just return the original array there instead, but as you noted that might not be fully intuitive.

A ASV for 1D- and ND-interpolation and having it running in the CI would be nice. Though I'm not really interested in implementing that, It would be just another thing to document for me because I use other profilers anyway and as you said getting it setup requires some work that I don't enjoy.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Do not transpose 1d arrays during interpolation 931016490
886247722 https://github.com/pydata/xarray/pull/5542#issuecomment-886247722 https://api.github.com/repos/pydata/xarray/issues/5542 IC_kwDOAMm_X8400xEq Illviljan 14371165 2021-07-25T19:36:12Z 2021-07-25T19:36:12Z MEMBER

Yes this improves the interp performance a bit. The .copy in the transpose is rather slow so it seems better to just not do it. An alternative is removing the .copy in the transpose or make it an option?

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Do not transpose 1d arrays during interpolation 931016490
869223054 https://github.com/pydata/xarray/pull/5542#issuecomment-869223054 https://api.github.com/repos/pydata/xarray/issues/5542 MDEyOklzc3VlQ29tbWVudDg2OTIyMzA1NA== Illviljan 14371165 2021-06-27T21:00:55Z 2021-06-27T21:01:17Z MEMBER

It's just a simple copy/paste job at the moment. I welcome suggestions for a more elegant solution.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  Do not transpose 1d arrays during interpolation 931016490

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [issue_comments] (
   [html_url] TEXT,
   [issue_url] TEXT,
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [updated_at] TEXT,
   [author_association] TEXT,
   [body] TEXT,
   [reactions] TEXT,
   [performed_via_github_app] TEXT,
   [issue] INTEGER REFERENCES [issues]([id])
);
CREATE INDEX [idx_issue_comments_issue]
    ON [issue_comments] ([issue]);
CREATE INDEX [idx_issue_comments_user]
    ON [issue_comments] ([user]);
Powered by Datasette · Queries took 1036.469ms · About: xarray-datasette