search

R0tenur / visualization

MIT License
173 stars 26 forks source link

Remove correlated subqueries for MSSQL #64

Closed bruce-dunwiddie closed 2 years ago

bruce-dunwiddie commented 2 years ago

Removed correlated subqueries to speed up schema queries for MSSQL.

https://github.com/R0tenur/visualization/issues/29

Objects in different schemas should be considered at some future point.

R0tenur commented 2 years ago

Again I want to thank you for this PR! I knew my query was kind of shitty but did not expect that much of speed improvement, hopefully this will result in less timeout errors.

bruce-dunwiddie commented 2 years ago

@R0tenur sure. feel free to tag me on any query/schema type things, especially in MSSQL, to ask questions or see if I can help.

R0tenur commented 2 years ago

Thank you! I probably will!