refactor(event cache store): use a single transaction to handle all linked chunk updates at once

refactor(event cache store): use a single transaction to handle all linked chunk updates at once #2352