0xDBE

Dear All,

I have asked a SO question, about a way to avoid initial scema scan, or make it less aggressive
http://stackoverflow.com/q/28903961/1601606


I haven't get any answer, so I have decided to post question here, as you probably doesn't monitor Stack Overflow.

In short - problem is, that we have a huge DB, and starting 0xDBE takes ages, and seems to disturb DB normal operation during this time. Probably lock it into one huge transaction. Is it possible, to avoid that scan?
And is it possible to grab that indices(cahces, or some internal structure, which is created during that scanning time) and disstribute it between developers, to avoid them doing their own scan, or speed-up it?

It's really nice tool, but at current moment it's impossile to use on real db. I'm looking forward getting rid of sqldeveloper.

Kind Regards,
Pavel.

P.S. Real DB is "Oracle Database 11g Enterprise Edition" v11.2.0.4.0

2 comments
Comment actions Permalink

Hello Seagull,

Indeed there is a related issue about Oracle schema synchromization logged https://youtrack.jetbrains.com/issue/DBE-137 . The good news are that we have implemented new DB introspection which will increase the performance in this regard. You may follow DBE-137 YouTrack issue on updates (please see https://intellij-support.jetbrains.com/entries/23368682 if you are not familiar with YouTrack).

Please also note that you may limit schemas to synchromize in Data Source Properties dialog Advanced tab.

And is it possible to grab that indices(cahces, or some internal structure, which is created during that scanning time) and disstribute it between developers, to avoid them doing their own scan, or speed-up it?

It is possible to share dataSources.ids and dataSources.xml files located in `.idea` folder under the `~\.0xDBE10\config\projects\<your_project_name>`. The files are store information specifit to configured in project data sources: connection settings, shemas information.

0
Comment actions Permalink

Thank you for answer!

I'll do recommended actions this or next evening. If you don't mind I'll also put solution summary in SO question.

Have a nice day!

0

Please sign in to leave a comment.