Speed up BAQ refresh in Dashboard

Usually just good SQL practices:

  • Limit records before linking (use the SubQuery)
  • Make sure to utilized indexes during linking and selection
  • reduce the number of fields to the minimum
1 Like