Explorer loading extremely slow in large environments #20
Description
Describe the bug
When connecting to a large Teradata deployment (thousands of databases and schemas, millions of tables/views) the explorer queries take forever to run. More than that, the explorer queries entirely block execution of editor code.
To Reproduce
Steps to reproduce the behavior:
- Connect to Large Teradata cluster
- Click on connections
- Expand browser
- Notice how terribly slow this is
- Attempt to run a query through an editor window
Expected behavior
The explorer should be very fast. I'm not entirely sure about the best way to resolve this, but my current idea is to have an as-needed explorer option which will load objects as they're needed instead of trying to load everything as soon as the drop-down is hit. Further, I would cache the results on disk so the same query isn't constantly run (adding a cache would also require adding some form of right-click clear-cache or maybe just a refresh button).
Screenshots
N/A
Desktop (please complete the following information):
- OS: Windows 10