VERY slow performance with many databases Follow
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 :)
Please sign in to leave a comment.
What database vendor is it? Do you see any progress bars at the right bottom of the IDE?
SQL Sever running on Azure.
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.
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?
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.
I just found an article to turn of "AutoSync"... .Works great and fast now : )
The whole point of AutoSync is to have your DataGrip objects synced with updates on SQL Server. Turning it off would make your DataGrip objects stale. This is my first day using DataGrip and I tried to open 50GB database with thousands of objects and dozens of schemas (yes, I nee them all). SSMS with RedGate SQL Toolbelt performs super fast in comparison to DataGrip regardless of database size.
@JB team, How's indexing schemas so slow in one product and fast in the other? Maybe I'm missing something. Let's say I leave it to sync for an hour and it finishes. What if schema changes and/or I refresh database from backup? I don't want to touch CPU - hardware resources concept should be irrelevant to users here.
Mikhail Zavar,
Could you invoke Diagnostic Refresh action and attach produced logs or email them to me Vasily.chernov@jetbrains.com?
Introspection is still a deal breaker. Accessing PostgreSQL databases exclusively (11,14,15). Accessing ~ 60 servers with 2-5 databases per server 1 -20 TB databases. I just added a new server. 5 minutes of "Introspection" later I get a connection error. It wants me to put a database extension, from a Linux PostgreSQL installation, on my Windows desktop box.
Richard Coleman your issue is different. Please comment in https://youtrack.jetbrains.com/issue/DBE-16457/Do-not-fail-introspection-task-if-there-is-error-in-some-extension-retrieval
The fix should have been included in DataGrip 2022.3 EAP: https://www.jetbrains.com/datagrip/nextversion/
Konstantin,
Thanks for chiming in. I believe that I have multiple issues, the extension issue, and the glacial introspection issue. Granted the first is probably a separate issue, the second issue though sounds like the same, or at least very similar, to what the original poster posted.
Richard Coleman you are right. Let's continue troubleshooting that in ticket. I passed that to responsible QA engineer, so they can deep into the introspection timings.