How can we help you today?

Start a new topic
Discussions Forums Analyze - Deep Dive player analysis
Answered

Direct Access Query Speed

Hi,


I'm having problems to run queries via DBeaver. For complex queries it's running forever and a really simple one takes several minutes (previously it would take like a few seconds).

Best Answer

This sounds more like a client side problem as the Vertica database that your Direct Access queries are running on is not showing any long running queries or performance issues. 


Can you check that you have the auto-commit setting enabled on your dBeaver connection as shown in the attached images and perhaps try killing and restarting dBeaver.




regards, 

Laurie

 

2 CommentsSorted by Oldest First
Answer

This sounds more like a client side problem as the Vertica database that your Direct Access queries are running on is not showing any long running queries or performance issues. 


Can you check that you have the auto-commit setting enabled on your dBeaver connection as shown in the attached images and perhaps try killing and restarting dBeaver.




regards, 

Laurie

 

 Hi,


I have not changed settings. Anyway, it's OK now and queries are running fast. All I did was to kill & start again DBeaver.

Login or Signup to post a comment
More topics in Analyze - Deep Dive player analysis