• Replies 1 reply
  • Subscribers 139 subscribers
  • Views 565 views
  • Users 0 members are here
Options
Related

Time-to-execute for object creation and update API calls varies widely

Colin Ferguson

We're performing a mass migration of content into a new SDL TD instance. Our import process makes many object creation API calls, in batches. We’re noticing that the time it takes to create each object varies a lot. Even objects of the exact same size, or different versions of the same object, or different language instances of the same object, can vary from 1 to over 8 seconds. What causes these wide differences? Note that this occurs whether or not there is other traffic on the server. The SQL server instance and the network seem to be functioning steadily.

Note that we’re seeing the same behavior with object update calls.
Rate translation
×
Suggest better translation
×

  • Hi Colin,

    The shortest information string to specify software behavior, is its version string. So on which version are you? Slight smile

    Generic answer is that all operations are using database transactions, so if you are in a hotspot then things can start queuing up. For example

    • Adding new objects in the _same_ folder means security checks will be triggered
    • Adding new versions and/or languages within the same logical object will trigger consistency checks as you can not have 2 objects labelled version 2 or language es-ES. The latter we call logical locking, so adding 10 versions to the same logical object will be serialized.
    • ...

    Tooling like Content Importer on Tridion Docs 14 keeps that in mind, and as a client optimizes the route.

    -Dave