VERY slow performance with many databases

Answered

I love DataGrip but recently I have a client who has over 600 databases on their server.   I need access to all of them as needed.   DataGrip is choking bad as far as me getting to list of tables for a particular database.   It might take 15 minutes to get the tables to show up on one singular database.  I can use SSMS and it is instant access and just works even with all the tables.   I hate SSMS that's why I pay for DataGrip but seems to be issue with server with hundreds of databases.  (Not my choice I didn't create them... I think that many on a server is stupid).  But I have to work with the client :) 

6 comments
Comment actions Permalink

What database vendor is it? Do you see any progress bars at the right bottom of the IDE?

0
Comment actions Permalink

SQL Sever running on Azure.  

0
Comment actions Permalink

I'm only selecting the scheme's I want in datagrip.  But if I have to add a new database it takes almost 30 minutes before I can see tables and things and actually work with it.

0
Comment actions Permalink

Do you see which process takes a significant time at the bottom-right panel of the IDE? Can you collect the IDE logs (Help | Collect Logs and Diagnostic Data), upload them to https://uploads.jetbrains.com/ and provide its ID?

0
Comment actions Permalink

It always says it's doing "Introspect".   Another thing that doesn't help it is pulling in the Replication tables as well and probably inspecting them.   We have 2 servers that are replicated.  

0
Comment actions Permalink

I just found an article to turn of "AutoSync"... .Works great and fast now : ) 

0

Please sign in to leave a comment.