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.59k stars 909 forks source link

Table is very slow to populate when query includes geometry/geography column #13671

Open siromega opened 3 years ago

siromega commented 3 years ago

Steps to Reproduce:

  1. Have a table in the DB that contains geometry or geography. In my case I used a table that had the 3200+ counties of the United States.
  2. Run a select query against the table by itself. If the table has more than a few hundred records and the geometry/geography is in the dataset returned, Azure Data Studio takes a long time to render the table even after the row counter at the bottom reaches the rowset returned.
kburtram commented 3 years ago

@aasimkhan30 this sounds similar to the other query grid perf issues you're investigating.