Solved

high latency

  • 11 February 2021
  • 2 replies
  • 33 views

Hi, please how to optimize my sql queries to get results faster. I have a model with only 2 joins but when I run sum measure it takes 20 min to displayMy database is bigquery
explore: store {
join: dv_purchase {
type: left_outer
relationship: one_to_many
sql_on: ${store.id_store}=${dv_purchase.id_store} ;;
}

join: dig_orders {
type: left_outer
relationship: one_to_many
sql_on: ${store.cd_store}=${dig_orders.code_store} ;;
}
}
icon

Best answer by IanT 11 February 2021, 19:36

I would take a guess that you are missing a join key, maybe orderid on the orders join.

View original

2 replies

Userlevel 6
Badge

I would take a guess that you are missing a join key, maybe orderid on the orders join.

I would take a guess that you are missing a join key, maybe orderid on the orders join.

@IanT  join keys are correct

Reply