home / github

Menu
  • Search all tables
  • GraphQL API

issues_labels

Table actions
  • GraphQL API for issues_labels

31 rows where labels_id = 2093067580

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Link labels_id issues_id
626211658,2093067580 performance 2093067580 Ability to configure keyset pagination for views and queries 626211658
642572841,2093067580 performance 2093067580 Database page loads too slowly with many large tables (due to table counts) 642572841
642652808,2093067580 performance 2093067580 Script to generate larger SQLite test files 642652808
643510821,2093067580 performance 2093067580 Set an upper limit on total facet suggestion time for a page 643510821
707849175,2093067580 performance 2093067580 static assets and favicon aren't cached by the browser 707849175
751195017,2093067580 performance 2093067580 Accessing a database's `.json` is slow for very large SQLite files 751195017
778530523,2093067580 performance 2093067580 /-/static should be excluded from auth and permission checks 778530523
782708469,2093067580 performance 2093067580 Take advantage of sqlite-utils cached table counts, if available 782708469
792652391,2093067580 performance 2093067580 Experiment with PRAGMA mmap_size=N 792652391
797651831,2093067580 performance 2093067580 Tests are very slow.  797651831
799663959,2093067580 performance 2093067580 gzip support for HTML (and JSON) responses 799663959
830567275,2093067580 performance 2093067580 Research using CTEs for faster facet counts 830567275
906385991,2093067580 performance 2093067580 CSV ?_stream=on redundantly calculates facets for every page 906385991
908446997,2093067580 performance 2093067580 ?_nocount=1 for opting out of table counts 908446997
944870799,2093067580 performance 2093067580 Big performance boost on faceting: skip the inner order by 944870799
964322136,2093067580 performance 2093067580 Manage /robots.txt in Datasette core, block robots by default 964322136
970626625,2093067580 performance 2093067580 Turn off suggest facets on tables with large numbers of columns 970626625
1055469073,2093067580 performance 2093067580 Research: CTEs and union all to calculate facets AND query at the same time 1055469073
1079149656,2093067580 performance 2093067580 Optimize all those calls to index_list and foreign_key_list 1079149656
1082564912,2093067580 performance 2093067580 `?_nosuggest=1` parameter for disabling facet suggestions on table view 1082564912
1096536240,2093067580 performance 2093067580 run analyze on all databases as part of start up or publishing 1096536240
1113384383,2093067580 performance 2093067580 Avoid ever running count(*) against SpatiaLite KNN table 1113384383
1154399841,2093067580 performance 2093067580 Sensible `cache-control` headers for static assets, including those served by plugins 1154399841
1163369515,2093067580 performance 2093067580 query result page is using 400mb of browser memory 40x size of html page and 400x size of csv data 1163369515
1174708375,2093067580 performance 2093067580 Streaming CSV spends a lot of time in `table_column_details` 1174708375
1179998071,2093067580 performance 2093067580 Mechanism for disabling faceting on large tables only 1179998071
1216622905,2093067580 performance 2093067580 Performance question - what is happening in this gap? 1216622905
1223699280,2093067580 performance 2093067580 .db downloads should be served with an ETag 1223699280
1384549993,2093067580 performance 2093067580 Setting to turn off table row counts entirely 1384549993
1400083043,2093067580 performance 2093067580 inspect data is not used for caching database hash 1400083043
1726531350,2093067580 performance 2093067580 Datasette should serve Access-Control-Max-Age 1726531350

Advanced export

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

CSV options:

CREATE TABLE [issues_labels] (
   [labels_id] INTEGER REFERENCES [labels]([id]),
   [issues_id] INTEGER REFERENCES [issues]([id]),
   PRIMARY KEY ([issues_id], [labels_id])
);
CREATE INDEX [idx_issues_labels_issues_id]
                ON [issues_labels] ([issues_id]);
CREATE INDEX [idx_issues_labels_labels_id]
                ON [issues_labels] ([labels_id]);
Powered by Datasette · Queries took 13.706ms · About: github-to-sqlite
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows