Domain designer with virtual data source is very slow

Problem : 

When designing a domain that connects to a virtual data source (usually Oracle, you can try it for other DBs as well), sometimes you might encounter a slowness when selecting fields and making joins.

Solution : 

Oracle schemas in VDS take a little longer to load than other DBs, you can however work around this by making the following changes : 

• In the WEB-INF folder, update the file applicationContext-semanticLayer.xml by changing the property skipDomainDatabaseValidation below to true  
• In the WEB-INF folder, update the file applicationContext-virtual-data-source.xml by changing the properties below to false : 

• importer.importForeignKeys

• importer.importKeys