Unable to view list of tables for a database when a lot of tables exist

sqlectron / sqlectron-gui

A simple and lightweight SQL client desktop with cross database and platform support.

https://sqlectron.github.io/

MIT License

4.54k stars 523 forks source link

Unable to view list of tables for a database when a lot of tables exist #307

Open aackerman opened 7 years ago

aackerman commented 7 years ago

I connect to a sql server database where surrounding systems dynamically create tables to partition data. The database currently has 18k tables. When I attempt to expand the database to view the tables list in the left-hand column the window essentially becomes unusable.

I can understand that this is not a common case and it may not be a high priority, but it would be nice for sqlectron to be able to handle displaying any number of tables in a database.

maxcnunes commented 7 years ago

What exactly do you mean by becomes unusable?

The list of tables is too huge and take over the whole sidebar?
The app become too slow to use?
Only the scroll in the sidebar is too slow to use?

aackerman commented 7 years ago

Unable to scroll sidebar, dozens of second delays to click any links, dozens of second delays to type into sql editor.