microsoft / vscode-tools-for-ai

Azure Machine Learning for Visual Studio Code, previously called Visual Studio Code Tools for AI, is an extension to easily build, train, and deploy machine learning models to the cloud or the edge with Azure Machine Learning service.
Other
324 stars 94 forks source link

Improve telemetry dashboard queries performance #2218

Closed sevillal closed 11 months ago

sevillal commented 11 months ago

Completed.

Improvement

Last 30 days query is **55% faster from 30sec to 13sec**

What was done?

  1. Created an aggregation table VSCodeAzureMLRemoteConnectionEventsDaily with all vscode events associated with our remote connection that is populated everyday with this lens job
  2. Created an aggregation table VSCodeAzureMLRemoteWebEventsDaily with all the events from the remote web extension that is populated daily with this lens job