Tested modeling very large relational models and quickly ran into performance issues in Designer.

With Heap size set to 512K I could really only work with models < 30MB in size. Bumping the heap size to 1024K allowed creation of 72MB model. This equates to ~400,000 columns. I was also able to Clone the project and create a second 72MB model. However any kind of editing became unbearable as soon as I maxed out on Memory usage ~ Heap size.

Finished testing by closing both projects (145MB of models) and it took a couple of hours to close.

Bottom line is there is a practical limit to how large your model/project set can be before modeling becomes an unbearable task.

We need to fix this, but I'm afraid it won't come until DNA comes online so we don't have to load all model objects (and their properties) in memory.

In the meantime, we should warn users (i.e. Know issue).