Hi all,
we are observing a strange problem:
Our imports for one specific object type in one object scheme takes almost forever, if we add a new attribute to be included.
The object type consists of about 650k objects, which is quite large. We also have object types with about 50k objects, that do not face such an issue (but maybe it is identical but not visible due to lower size).
We need to add a new attribute to the object type, where all the data already exists in an external database. So it would be a simple import and set values.
Creating a new object type and import the entire data set is working fine (takes some time, but that is expected). This import finished within 2-3hours.
When running an identical import with the existing objects, the will be updated with the new attribute. And each of these updates takes 1,5seconds (which sums up to 270h for all 650k objects). This is not practical and I do not understand the reason for update being slower then create of an object.
I have also been able to narrow it down to the following API method, which consumes almost all of the mentioned 1,5s:
objectFacade.storeObjectBean(mutableObject)
As this is a similar behaviour to the built-in import function, I am suspecting something wrong either on DB level or else where in the system.
Does anyone of you know about similar behaviour? I can't imagine that this should be a limitation of Assets if Atlassian themselves are speaking about millions of objects.
Hopefully you have encountered this already in the past and could let me know some improvements :)
Thanks for your help!