airbnb / superset

70%

master: 0%

LAST BUILD ON BRANCH crud_optimizations

branch: crud_optimizations

CHANGE BRANCH

x

Reset

• crud_optimizations
• master
• airbnb_prod
• kim/fix_druid_datasource_bug
• kim/test_key
• redirects
• chris/sunburst-conditional-percent
• chris/remove-random-power-units
• pinpandas
• 0.8.5
• fix_delete_datasource
• panels
• panels2
• sqla_config
• better_welcome
• chris/msgs-to-modals
• chris/sankey-refresh
• add_slice
• docs_gallery
• add_slice_redirect
• druid_origin
• bar_y_axis_format
• reshift_grain
• future_imports
• big_number_total
• 0.8.6
• chris/heatmap-fixes
• edit_table_url
• fix_292
• sankey_loop
• credits
• table_overflow
• thumbs
• fix_landscape
• lint
• fix_sql
• dumps_dates
• version_cli
• schema_fix
• kim/fix_logging
• chris/sankey-improvements
• numbers
• fix_welcome_order
• thumbs2
• 0.8.7
• fix_missingds
• type_detect
• hide_pass
• 0.8.8
• fix_pk_table
• error_handling
• version
• fix_db_upgrade
• use_2to3
• druid_mock
• pypi_class
• examples_as_tests
• druid_tests
• security
• 0.8.9
• chris/fix-sunburst-level-trunc
• para
• 0.9.0
• fix_welcome
• druid_regex
• trans_more
• fab162
• owners_save
• travis_matrix
• celery
• 0.9.1
• expose-slice-id-endpoint
• orderby
• run_q
• 0.10.0
• revert-685-run_q
• d3format_by_metric
• carapal
• ascott-update-webpack-config
• chris/support-standalone-arg-in-slice-id-endpoint
• bkyryliuk-patch-1
• fix_question_mark
• fix_theme
• bogdan/query_status_polling
• refactor
• reset_theme
• refactor_viz
• bogdan/cta_as_separate_end_point
• sqllab
• schema_star
• alanna-explore-v2-main
• anigif
• xss
• filter-value-selector
• test_branch
• revert-1122-vliu_query_search
• request_access_dash
• 0.11.0
• refact_explore2
• airbnb_prod.0.11.0.1
• revert-1335-bogdan/grant_perm_to_role
• bogdan/grant_perm_to_role
• airbnb_prod.0.11.0.2
• airbnb_prod.0.11.0.3
• results_backends
• develop
• dummy
• airbnb_prod.0.11.0.4
• tgt-prod
• airbnb_prod.0.11.0.5
• fix_extending_role
• airbnb_prod.0.11.0.6
• 0.12.0
• revert-1465-fix_celery_dying_conn
• druid_topn
• caravel_macros
• airbnb_prod.0.12.0.1
• superset
• 0.13.0
• 0.13.1
• vliu_query_button_v2
• vliu_explorev2_select
• druid_latest_seg
• vliu_dashboard_fix
• fix_grain
• vliu_dashboard_standalone_v2
• table_sort
• more_dash_tests
• vliu_resize_explorev2
• vliu_put_datasource_in_store
• 0.1.0-dev
• vliu_fix_explore_v2
• vliu_solve_sqllab_height_problem
• 0.13.2
• sqlparse/get_table_names
• user_profile
• vliu_reactify_save_modal
• vliu_delete_unused_components
• add_all_tables_endpoint
• table_paginate
• vliu_dashboard_bug
• smooth-nvd3-refresh
• add_users_to_roles
• vliu_add_ajax_alerts
• vliu_explorev2_viz_bug
• jinja_security
• logo
• fadeto
• vliu_alert_for_visualization
• perm_fix
• perm_cleanup
• vliu_nvd3_v2_bug
• vliu_filter
• vliu_query_search_scrollable
• vliu_query_search_loading
• vliu_auto_render_on_fields
• vliu_fix_querylink_bug
• vliu_defaultFormData
• push
• fetch
• airbnb_prod.0.12.1.0
• superset_staging
• exclude_robot_roles
• vliu_dashboard_view
• dashboard-save-as
• sql_preprocessor
• druid_having
• template_all
• fix_1689
• freeform_select_filter
• add_schema_perms
• fix_component_update
• vliu_explorev2_bugs
• link_profile
• vliu_emailto_slice
• vliu_save_modal_bug
• deploy
• druid_hot_fix
• vliu_autocomplete_bug
• airbnb_prod.0.13.0.0
• airbnb_prod.0.12.0.2
• 0.14.0
• 0.14.1
• byolken/support_pex
• fix_sqllab_cta
• vliu_visualize_modal_bug
• handdev
• 10105
• vliu_welcome_login
• fix_perms
• vliu_responsive_chart_container
• full_datasource_name
• vliu_sqllab_overwrite_editor
• vliu_overwrite_sql
• vliu_overwrite_sqleditor
• vliu_textfield_bug
• vliu_textfield_v2_bug
• tgt-superset
• fix_dup_cols
• airbnb_prod.0.13.0.1
• btn-retrieve
• byolken/remove_unused_symlinks
• throw-away
• bugfix_bignumber_neg
• source_map
• vliu_query_search_order
• v2_input_size
• vliu_copy_entire_menuitem
• dsl
• ddol/sankey_tooltip_bug
• sync_users_by_username
• stop_creating_dup_perms
• avoid_tiny_font_size
• metrics
• sync_roles_and_create_users
• vliu_customize_table_filter
• handle_object_exp
• update_sqllab_perms
• airbnb_prod.0.13.0.2
• vliu_copy_url
• break
• airbnb_prod.0.13.0.3
• simplifyer
• vliu_dual_line
• vliu_query_output
• buttons
• vliu_button_tooltips
• default_db
• vliu_add_viz_thumbnail
• fix_bignum
• vliu_explore_timer
• vliu_count_distinct_metrics
• init_opt
• vliu_update_chart_v2
• druid_dashboard_export
• 0.15.0
• newSliceTest
• v2_hotfix
• fix-hardcoded-urls
• unused_sql_clause
• scroll
• disabled
• reduxtools
• css_v2
• clearable
• fix-hardcoded-urls-python
• HEAD
• sqllab_async
• airbnb_prod.0.15.0.1
• fix-hardcoded-url-python
• fab_hack
• log_time
• inside_out
• bugfix_semi_query
• return_sql
• space
• map_props_to_contrl
• v2_time_up
• 0.15.1
• vliu_slice_list
• vliu_persist_explorev2
• vliu_add_sliceview_class
• fix_standalone_heiht
• fix_1896
• moretypesjsonserializer
• vliu_async_select
• sql_lab/full_text_search
• vliu_hotfix
• validators
• revert-1811-druid_dashboard_export
• fix1910
• v2_touchups
• 1131_add_tests
• vliu_dualaxis_bug
• vliu_visualize_long_query
• fix_the_fix
• revert-1667-vliu_dashboard_view
• switch-order
• vliu_explore_query
• fix_none_view_menues
• vliu_share_long_query
• vliu_check_access
• version_info
• email
• revert_cli_changes
• vliu_count_metric
• permission_cleanup_one_off
• 0.15.2
• fix_filtering_on_int
• validate_2
• vliu_filter_field
• simplify_vizes
• sql_lab/default_result_backend
• 0.15.3
• fix_login_redirects
• fix_sql_fetch_result_perms
• 0.15.4
• vliu_cleanup_dar_hotfix
• realisnum
• sql_lab/fix_csv
• objects_to_json
• vliu_timeshift_validator
• vliu_async_results
• vliu_save_slice_v2
• vliu_dual_line_tooltip
• revert-2055-vliu_async_results
• vliu_async_resultset
• vliu_search_failed_queries
• vliu_druid_having_filter
• fix_table_view
• vliu_view_query
• vliu_query_v1
• vliu_remove_fetch_button
• celery_workers
• sql_lab/fix_viz
• fix_druid
• vliu_dual_axis_order
• v_0.15.4.1
• airbnb_prod.0.15.4.1
• fix_time
• bump_limit
• byolken/s3_cache_implementation
• vliu_default_time_query_search
• vliu_presto_error
• vliu_parse_nested_results
• vliu_stop_query_sqllab
• vliu_save_queries
• add_crontab
• deprecate_v1
• 0.16.0
• vliu_filter_endpoint
• clean_cli
• fix_cache
• vliu_bugfix_getFieldsState
• vliu_parse_dbid
• rename_field_control
• sql_lab/cache_force_reset
• sql_lab/hive_support
• fix_filter
• sql_lab/fix_refresh_queries
• sql_lab/fetch_schemas
• refact_chart
• fix_table_explore
• druid/support_post_agg
• fx_trailing_slash
• fix_css_editor
• fix_caching_errors
• ascott-v0.16.1
• 0.16.1
• vliu_default_overwrite
• ascott-v0.16.1rc1
• vliu_parse_filter_values
• vliu_save_new_slice
• vliu_save_slice_id
• ascott-v0.16.1rc2
• fix_tally
• fix_tally_2
• fix_bars
• fix_table_dates
• vliu_fix_regex_filter
• fix_filters
• fix_sankey
• vliu_druid_filters
• revert-2291-vliu_druid_filters
• fix_table_default
• vliu_save_modal_spec
• vliu_scroll_chart
• vliu_filter_spec
• more_filters
• tableViewAddTimeShift
• vliu_fix_breakdown
• ascott-v0.17.1
• fix_filter_table
• ascott-0.17.0rc1
• blueprints
• ascott-0.17.1rc1
• delay_filter
• fixSupportMoreDruidPostAgg
• fix_getter
• fix_master_dup
• fix_partition_query
• druidQuantilesDisplay
• refs/tags/v0.0.1
• connectors
• fix_hive_engine
• chart_component
• templates
• fix_table_sort
• mytest
• names
• time_updates
• sqllite_month_time_grain
• stop_query
• fix_csv
• templates_fixed
• display_error
• fix_d3f
• fix_filtesr
• preprocess_where
• sqllab_array_conv
• vliu_query_response
• fix_tablecolumn
• column_type
• 0.17.1
• display_partitions
• db_name
• more_connector_refact
• update_perms
• fix_x_scroll
• compare
• fix_sql_clauses
• fix_percent
• speed_poll
• fix_type_inference
• pylint
• fix_fix
• redirect_explore
• dep_is_featured
• docs_public
• ascott-0.17.2rc1
• fix_security
• fix_mq_down
• fix_filers
• filter_box_css
• fix_pending
• css_background
• fix_spinners
• scroll_bar
• 0.17.2
• saved_queries
• url_param_sql
• 0.17.3
• clarifications
• basestringdruid
• pylint2
• default_metric
• fix_browser_freeze
• fix_save_dash
• fix_save_slice
• fix_db_saved_query
• csrf
• 0.17.4
• select_db
• vertica_install
• bump_py_libs
• current_user_macro
• form_data_template
• addmissingflaskwtf
• fix_query_loading
• dash_refact
• pad_markup
• fix_alt_enter
• fix_sqlite_lab
• slice_owner
• fix_db_ordering
• js_bump
• bugfix
• fix_separator
• improve_err_msg
• better_cache
• slice_timeout
• fix_error_msg
• fix_dash_perms
• no_metrics_validator
• hive_adjust
• social_stats
• move_warning_msg_navbar
• druid_ts
• datasource_slices
• fix_having
• moretrans
• ascott-0.17.5-alpha.10
• 0.17.5
• optimize_standalone
• fix2660
• prop-types
• alternate_2665
• stats
• gg-update-changeEventHandlerName
• fix_vizflow_groupby
• fix_change_viztype
• fix2643
• fix_anon
• 0.17.6
• ecometrica
• sqllab_left
• fix_sqllab_csv
• fix_doubles
• gg-autoSelect
• remove_results_backend
• fix_missing_datasource
• fix_ctas
• fix_css_bug
• fix_stop
• no_part
• sqllab_adjust_width
• gg-sqlLab-remember-selectedSchema
• fix_presto_percent
• 0.18.0
• gg-queryTimeout
• end_result_backend_time
• fix_agg_types
• 0.18.2
• fix_db_order
• fix_user_time
• fix_escaping
• docs_filtering
• enable_filter_in_examples
• more_statsd
• viz_type
• gg-refactorVisualizeAjaxCall
• gg-addTestCoverage-VisualizeModal
• gg-addValidationRuleForVisualize
• fix_country_maps
• q
• supercat
• control_header_flex
• gg-VisualModalTests
• fix_sort_bars
• fix_limit_bubble
• fix_values_view
• gg-reduceClientTimeout
• save_as
• save_As
• ybounds
• gg-LongQueryVisualizeAdvise
• byolken__fix_tox
• byolken__fix_tox2
• docs_faq
• 0.18.3
• gg-fixLintingError
• gg-keepColumnsStateLocal
• gg-VisualizeModalColumnsAlignment
• csv-import
• csv-import-travis
• travisnoy3.5
• 0.18.4
• fix_in_numeric
• gg-DashboardTimeoutWarning
• bignum_tip
• fix_2814
• improve_bubbles
• remove-margin-dev
• remove-margin
• verbose
• development
• remove-whitespace
• remove-whitespace-2
• remove-whitespace-3
• notify_dash_save
• metric_ralign
• bump_py
• gg-ResultSetTestCoverage
• remove_unused_js
• gg-EditTitle
• ascott-update-contrib-docs
• pivot
• alanna-webpack-file-naming
• flower
• filterbox_verbose
• gg-ResultSet
• fix_template_from
• refresh_immune
• byolken_test
• gg-SalLabTestCoverage
• gg-fixIsOwnerCheck
• anomaly
• code_editor
• byolken__webpack_tweaks
• fix_uglify_npm
• fix_metrics_default
• import_export_ds
• byolken__revert_webpack_command_changes
• chords
• minor_fixes
• quotestacktraces
• gg-AddPythonTestsDevReqs
• gg-TestCoverageSqlLab
• control-test
• 0.18.5
• paired-ttest-viz
• gg-SlicesTemplate
• fix_ts
• fix_markup
• gg-CheckboxAlignment
• gg-ClarifyTimeoutConfig
• bumpcrypto19
• typedfillnae
• throttleresize
• gg-ExploreViewSplitReducerLogic
• gg-ExploreViewSaveModalSpec
• pivot_totals
• filterable
• reraisesqllabgetresults
• gg-EnterEndEditingTitle
• change_button_description
• fix_missing_perms
• heat_val
• yarn
• fix_init
• sqla_warning
• sqla_warning2
• sqla_warning3
• fix_warn6
• api-testconn
• wolfe--add-postagg-escape-hatch
• yarn_docs
• delete_datasource
• fix_merge_perms
• refs/pull/3/head
• screwdriver
• oath
• refs/pull/5/head
• refs/pull/6/head
• refs/pull/9/head
• refs/pull/10/head
• refs/pull/11/head
• refs/pull/14/head
• refs/pull/15/head
• refs/pull/17/head
• refs/pull/19/head
• refs/pull/20/head
• refs/pull/22/head
• backend
• main
• airbnb-master

Build # 1058

Build Type

push

travis-ci

Committed by mistercrunch

Commit Message

Speed up all CRUD list views

Load times on list view pages like Slices, Dashboards, Tables and Database
have grown to be terrible over time.

After a bit of digging, I found that the not specifying `search_columns`
in ModelViews actually means "all columns" and that for each filter,
FAB goes and fetches a list of all values to prepopulate the
filter dropdowns. That means that the list of tables would fetch all
slices and all users upfront which is horrible. Worse, database list
view would fetch all queries with is insane.

This picks a subset of columns for search/filters and changes the
default to show only 100 elements per page instead of 500

Run Details

8 of 8 new or added lines in 5 files covered. (100.0%)

4247 of 6068 relevant lines covered (69.99%)

2.79 hits per line