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.58k stars 905 forks source link

In the case of slow network speed, you can only query #25405

Open lozn00 opened 8 months ago

lozn00 commented 8 months ago

Type: Bug

In the case of slow network speed, you can only query, the home page cannot be loaded, and the database cannot be displayed, but Microsoft SQL Server Studio is normal, I hope to optimize this problem, at least ensure that the database name should be displayed. Let me expand the database one by one, and then expand the database table and so on

Azure Data Studio version: azuredatastudio 1.45.1 (88c21b1725a3e79440027bdb7b5a55fb036be0e2, 2023-08-03T00:42:37.945Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|11th Gen Intel(R) Core(TM) i5-11400 @ 2.60GHz (12 x 2592)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|31.77GB (16.42GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (9) Extension|Author (truncated)|Version ---|---|--- StoredProcedureConverter|loz|0.0.1 ads-language-pack-zh-hans|Mic|1.45.0 asde-deployment|Mic|0.4.1 datavirtualization|Mic|1.13.2 machine-learning|Mic|0.12.0 query-history|Mic|0.5.3 ads-searcheverywhere|Mik|1.1.1 vscodeintellicode|Vis|1.2.1 poor-sql-formatter|WSR|0.1.0 (1 theme extensions excluded)
cheenamalhotra commented 8 months ago

@lozn00

Have you tried using the latest ADS release with connection pooling enabled?

image

We hope this improves performance by re-using connections where possible. Please try and let us know!