search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.56k stars 899 forks source link

Table designer is loading too slow #22025

Open drsa353 opened 1 year ago

drsa353 commented 1 year ago

Issue Type: Performance Issue

Two issues I have:

  1. The table designer is not loading fast as in SSMS
  2. ~It's misleading to select in item "like a table or view" from the treeview and it's node expand automatically, it's better the old school of select item is for selecting item and expad/collapse item is to expan/collapse the item.~ moving to https://github.com/microsoft/azuredatastudio/issues/22042 Thanks

Azure Data Studio version: azuredatastudio 1.41.2 (0f0960d0e774e1ce903b79378addff96117c27a6, 2023-02-08T20:16:49.071Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled

caohai commented 1 year ago

Hi @drsa353 For the first issue, there's a pre-loading setting that you can turn on to improve the performance of table designer. image

kburtram commented 1 year ago

@drsa353 thanks for providing this feedback! I've split the items into separate issues since that is easier for us to respond to and track. We can use this one for the table designer perf bug & the OE expansion suggestion is at https://github.com/microsoft/azuredatastudio/issues/22042.

alanrenmsft commented 1 year ago

@drsa353

  1. what type of server you are using?
  2. what is the network latency between your machine and the server
  3. how long does it take for the table to load in SSMS vs ADS?
garethpotter commented 1 year ago

I am also seeing this in 1.44.1 (and have for a while). Loading the table designer is hilariously slow. If I could use SSMS I would but I am on a Mac. No Internet connection issues (1 Gbps symmetric), server is Azure SQL Server and otherwise responds to queries from ADS in a timely manner.

ZealousCynic commented 5 months ago

Experiencing the same. Against a local database no less. At some point that's going to annoy me enough that I just drop this application.