I use DB Navigator in preference to DB Explorer but others here prefer DB Explorer. We have had some performance issues with DB Explorer on 6.3 so I thought I would test performance on the latest beta.
The performance has not improved and is taking over 3 minutes to return the list of tables in a schema in DB Explorer. In DB Navigator it is taking under 5 seconds.
I ran the SQL monitor tool and the issue does not seem to be tied to the underlying queries.
DB Navigator query Elapsed time: 0.016
DB Explorer query Elapsed time: 0.391
So it appears the query is running fine ( a fraction slower but still under a second) but the results are taking a very long time to display.
This is only on the initial display as obviously the results are cached after that. As expected though if you do a refresh then there is the same type of delay.
There are over 1500 tables in this schema but I wouldn’t expect that is an extreme amount.
Just wondering if this is a known issue or being experienced by others.