When I am editing a datawindow in the IDE and switch from design mode to the Data Source, it takes a very long time. It might take 3 minutes or more for the SQL query to be displayed, which is harmful to the speed of development.
This may have something to do with the data model being very large (around 1000 tables). Sometimes, the wait time is much smaller (10 seconds or so), in the quiet hours when there are few developers accessing our Oracle server. It does not depend on the size or complexity of the query.
Does anybody know what factors influence the wait time? Are there any settings that can be tweaked? It would be a huge time-saver for my team.