mercredi 15 juin 2016

Simple queries take very long

When I execute a query for the first time in DBeaver it can take up to 10-15 seconds to display the result. In SQLDeveloper those queries only take a fraction of that time.

For example: Simple "select column1 from table1" statement

DBeaver: 2006ms, SQLDeveloper: 306ms

Example 2 (other way around; so theres no server-side caching): Simple "select column1 from table2" statement

SQLDeveloper: 252ms, DBeaver: 1933ms

DBeavers status box says:

  1. Fetch resultset
  2. Discover attribute column1
  3. Find attribute column1
  4. Late bind attribute colummn1

2, 3 and 4 use most of the query execution time.

I'm using oracle 11g, SQLDeveloper 4.1.1.19 and DBeaver 3.5.8.

See http://dbeaver.jkiss.org/forum/viewtopic.php?f=2&t=1870

What could be the cause?

Aucun commentaire:

Enregistrer un commentaire