Hi I'm using
SQL Developer Data Modeler (SDDM) 22.214.171.1246 x64
and I''ve a big problem.
I've a schema with about 2800 tables and 4800 Ref Constraints.
In the ER Model i keep only Tables Indexes and Constraints, not Views, not Triggers, Not PL/SQL Code
The data saved on Hard Disk by SDDM is about 63Mb ì, but when I open the model the memory occuped by the process is more than 1GB.
And is impossible use the Model, and I've 8GB of Ram on Win 7x64 Professional
If not possible reduce the consume of the RAM, is possible make sure that the program don't hand when arrive at 1GB?
and I've 8GB of Ram on Win 7x64 Professional
You can give more memory to Data Modeler - you need to change in datamodeler64.conf
change 768 to 4000 or to value that works for you.
And of course you need to use 64 bit JDK.
In "save" operation DM also saves status of diagram (close/open). Keep the number of open diagram to minimum, avoid to keep main diagram open because rendering of diagram will slow load process.
And as Joop said you can try to split the model to smaller models.
You can also make subviews, but since all objects are in one relational model, the loading time of the design is still long.
By splitting in relational models you can select during opening of the design which relational model(s) you want to open. Only these relational models will be opened, and this saves time!
You can refer to objects (tables and views) of different relational models of the same model by making a linked version of the object you want to use. You can achieve this by opening a subview on relational model A, and then drag an object of relational model B in the subview of A. As a result a linked object is created. You can recognize them by the chain symbol in the icon and the chain symbol in the object representation in the subview.
In this way you can also maintain the foreign keys between the tables.