Adding experiment design as a field to Experiment entity cause a memory issue

[ke4]

The added experimentDesign field for the Experiment entity is hugely increasing the memory usage when we load the experiments into the cache. I added that change to put back experiment design tab to Bulk Expression Atlas. That was clearly a wrong solution considering this is breaking Single Cell expression Atlas as the Experiment entity is commonly used in both.

It looks like the main problem is in this commit: [Bugfix] Update codebase to latest web core ( in this line: https://github.com/ebi-gene-expression-group/atlas-web-core/blob/ea4ce65ab9267101ba3390843221604fc6948a96/src/main/java/uk/ac/ebi/atlas/model/experiment/Experiment.java#L37

We need to find a solution to load the experiment design data in a different way and not store it in the cache.

[ke4]

After some research I found the following regarding the above issue in the Experiment class:

• In SCXA the experimentDesign field and getExperimentDesign() method call is not used, only for populate with values, but the values are never used
• In bulk the experimentDesign field and getExperimentDesign() method call are heavily used