Find a better way to update parents size

[unmade]

We need to find a better way to store folder size.

Current flow is to update all parents on moving/uploading a file to folder. This however leads to concurrent transactions updating the same parents.

[unmade]

Current reconciliation doesn't calculate folder sizes. This is because of performance optimisation. However, after reconciliation we can restore folder size with query like this:

WITH Parent := File,
UPDATE File
FILTER
    .mediatype.name = 'application/directory'
SET {
    size := (SELECT sum((
        SELECT Parent { size }
        FILTER
            Parent.namespace = File.namespace
            AND
            Parent.path LIKE File.path ++ '/%'
            AND
            Parent.mediatype.name != 'application/directory'
    ).size))
};

[unmade]

One way to solve the problem is to store folder size in Redis using incr_by. That way we can avoid problems with transactions and concurrent updates.

Initial data for cache can be calculated using query above.