I am currently evaluating DataGrip and am finding that it works really well for relatively small databases containing a small amount of objects, however the main database I work with is very large containing thousands of objects and I'm having real performance issues.
After creating a new datasource connection (I've been testing with Oracle 11g), the object synchronisation takes upwards of 7 mins (getting on for 4,000 tables). This in itself isn't much of a problem because it only needs to be run every now and then, however I am experiencing a much larger issue (to me at least):
When opening the table listing (~3800 objects at present), the IDE freezes for approx 40 seconds while it is loading the table and index listing. This would be okay if it only happened the first time the listing was opened, however it appears to happen every time there is an interaction with the Database View. With the entire IDE locked up while this happenes (there is a large CPU spike during this process) I just have to wait until it's done. As a comparison, using Oracle SQL Developer, similar interactions are almost instentaneous.
Now, I understand that DataGrip is doing much more than SQL Developer... but is there any way to speed this interaction up?
For reference, I'm running DataGrip v1.0.1 on the Oracle v1.8 Java VM.
Thanks in advance.