Skip to content

AY-7956_Sync performance #242

@ynbot

Description

@ynbot

Please describe the enhancement you have in mind and explain what the current shortcomings are?

Syncing of entities AYON to Shotgrid can take a while especially in case of many shots. Real numbers are around 1 shot with 9 tasks can take around 1 minute. But it will quickly adds up - if you have large project with hundreds of shots, your sync can take hours then.

There are several possible ways to speed things up, most likely "batching" or "transactional" way where the sync isn't processing event after event but it waits for some chunk, prepare the batch and executes it. Or it works with transactions in similar way DB engines are - pool entities into transaction and commit it in the most effective way.

How would you imagine the implementation of the enhancemenent?

No response

Describe alternatives you've considered:

No response

Additional context:

link to discussion on Discord
(might be a private channel)

This issue was automatically created from Clickup ticket AY-7956

Metadata

Metadata

Assignees

No one assigned

    Labels

    sponsoredThis is directly sponsored by a client or community membertype: enhancementImprovement of existing functionality or minor addition

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions