Comments (8)
Ah, it is a neverending story about Oracle system schemas reading performance.
Please check this: http://dbeaver.jkiss.org/forum/viewtopic.php?f=2&t=1870&p=4484
It looks like Oracle 10/11/12 have some significantly differences here.
Could you also check Query Manager to see what metadata queries work so long?
from dbeaver.
Hi Serge,
inspecting the Query Manager it seems that the execution time of the background queries (launched by DBeaver when the References tab is opened) is very short (1255ms to fetch almost 20000 records).
However, the GUI still shows the progress bar scrolling and the real duration of the query seems far greater:
After the complete execution of the queries, the time span between one execution and another seems unrelated to the shown execution times:
The longest metadata queries are the following:
SELECT /*+USE_NL(cc)*/ c.*,cc.COMMENTS
FROM SYS.ALL_TAB_COLS c
LEFT OUTER JOIN SYS.ALL_COL_COMMENTS cc ON CC.OWNER=c.OWNER AND cc.TABLE_NAME=c.TABLE_NAME AND cc.COLUMN_NAME=c.COLUMN_NAME
WHERE c.OWNER=?
ORDER BY c.COLUMN_ID
SELECT /*+RULE*/
c.TABLE_NAME, c.CONSTRAINT_NAME,c.CONSTRAINT_TYPE,c.STATUS,c.SEARCH_CONDITION,col.COLUMN_NAME,col.POSITION
FROM SYS.ALL_CONSTRAINTS c
LEFT OUTER JOIN SYS.ALL_CONS_COLUMNS col ON c.OWNER=col.OWNER AND c.CONSTRAINT_NAME=col.CONSTRAINT_NAME
WHERE c.CONSTRAINT_TYPE<>'R' AND c.OWNER=?
ORDER BY c.CONSTRAINT_NAME,col.POSITION
The strange thing is this...
If you open another tab that requires a query on SYS tables like Triggers, the overall execution is very fast, so I don't know if this issue is reallly related to bindings as indicated in the topic you pointed me to... the binding delay should apply to these queries too, but they seem not affected by it.
from dbeaver.
When you making a select from a table from some schema for the first time DBeaver caches all tables, columns an constraints in that schema. In the progress bar you see it as "binding". It takes time. In case of SYS schema it takes pretty much time. But all consequent queries should work fast.
Although 30sec is more than too much. Unless you are working with remote Oracle using slow network.
I don't see (from QM log) what could take so much time. Or maybe there are a lot of short metadata queries in it?
from dbeaver.
Hi Serge,
yes, at work we have a remote Oracle server, but I don't suppose our network is so slow...
The Oracle DB resides on an Exadata machine and our LAN is 1Gbps grade.
I (hopefully) posted all the metadata queries that DBeaver performs :-(
from dbeaver.
I'll add a few metadata loading performance improvements.
from dbeaver.
Please check performance in 3.5.3
from dbeaver.
Hi Serge,
retrieval time for Foreign Keys has dramatically improved, however DBeaver is still a little slow when retrieving References (on a table it took up to a minute to complete the retrieval query, whether the retrieval of Foreign Keys took less than 5 seconds).
from dbeaver.
Same problem in informix.
Dbeaver version 6.0.4
from dbeaver.
Related Issues (20)
- Wiki documentation does not match ER Diagram Viewer behavior for creating new table HOT 1
- MySQL begin; ... rollback; stopped working in 24.0.3 HOT 3
- Sql console execute error when the script exist "delimiter ;;" HOT 2
- before 24.0 it was portable HOT 11
- DBeaver not considering all Primary Key Columns when Updating Data in Grid HOT 3
- Unexpected Error when connecting to redshift
- REDACTED
- Generate SQL option is not working on column section HOT 3
- MySQL script dont accept multiple USE command HOT 4
- Teradata edit CLOB setNCharacterStream function not supported in this version HOT 2
- Autocomplete for schema name doesn't work
- Save blob to file doesn't work for sqlite
- Malformed JSON Exception at start HOT 4
- Fix potential github action smells HOT 1
- [Sybase] Table statistic is not shown correctly HOT 1
- "word wrap" on/off state not preserved in the value editor while navigating through table cells HOT 1
- [Sybase]Disconnect after opening 3-7 metadata folders
- Add more keywords for smart block recognition HOT 3
- Search Function Not Highlighting Correct Schema HOT 15
- ollama support HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbeaver.