dbeaver icon indicating copy to clipboard operation
dbeaver copied to clipboard

Opening a connection takes a lot of time on `Read data types`

Open pyrocks opened this issue 2 years ago • 0 comments

Description

Related to #17117 - it happens in my case as well. I have a DB with a dozen schemas and ~315 enums. Whenever I open a connection to a remote DB the background task stays on Read data types for about 35 seconds before the connection is actually opened. suggestions:

  1. do this as a background task AFTER the connection is made
  2. lookup a data type when it's actually needed i.e describing or selecting from a table for the first time.

DBeaver Version

Community 22.2.0

Operating System

MacOS 12.6

Database and driver

postgres 12.4, default JDBC drivers

Steps to reproduce

create a remote (i.e cloud) database with many enums. open a connection to it

Additional context

it only happens when Connecting to a DB - it doesn't happen when invalidating the connection

pyrocks avatar Sep 18 '22 07:09 pyrocks