Avoid designing Anatella graphs with diamond shape in them: For example:
This is BAD:
This is GOOD (and it’s equivalent to the above BAD graph):
(Please note that we had to duplicate the FilterRows Action in order to remove the left diamond shape).
When there are some diamond shape inside a graph, Anatella is forced to create a temporary HD cache containing all the data. The extra I/O’s performed to create (and thereafter read) this HD cache cost a large amount of time and disk space (and should therefore be avoided). More precisely, Anatella automatically creates HD caches on the left-most-corner of the diamonds: here: