the action of loading data source when open the datagrip takes too long every time

Every time I open my datagrip the background job runs for loading data source takes long time to finish. 

During this time I can't execute any SQL statement.

Is this nromal ?

Please help.

Thanks a lot!

5 comments
Comment actions Permalink

how many data sources do you have in a project?

0
Comment actions Permalink

Hi Yuriy, thanks for your reply.

I have three datasource on remote clound and three sap hana datasource.

I encountered this problem for version 2021.2.4. I degraded to 2021.1.3 then the problem sovled.

But there are still another performance issue. Both version takes long time when I clicked "refresh" on SAP HANA datasource.

0
Comment actions Permalink

File -> Invalidate cache could help after update to make IDE start up faster, please try it.

And introspection process depends on database size (objects amount), so if you DB is quite big then it will take some time.

0
Comment actions Permalink

I also have this issue, i only have a few data sources but they can have hundreds of tables each. DG will try to introspect every one of them before i can even see my data, i usually only want to look at a single table. This can take 10 minutes.

0
Comment actions Permalink

Jleagle

Could you describe your environment?
Also, invoke Diagnostic Refresh action and send us logs or create a new issue in DataGrip bug tracker

0

Please sign in to leave a comment.