search

R0tenur / visualization

MIT License
173 stars 26 forks source link

Remove correlated subqueries for MSSQL #63

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

Needs to be tested on a case-specific MSSQL instance because some of the previous version code was not careful with casing. This code is not worse, and should be better, for casing.

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

R0tenur commented 2 years ago

Thank you for your contribution 👏 👏 👏 ! Really appreciated!

The postgres branch is stale and not under active development. It would be good if you could base the PR of the master branch since that's the one that's up to date with the latest features.

The file is then located in: src/backend/repositories/mssql.repository.ts