Improve performance of EA.Attribute.update

[Ian Mitchell]

I have an application which needs to create a lot of new EA classes, each with some class attributes.
I have done all the performance tricks I can think of, including Repository.EnableUIUpdate=false, but the slow part of the process still seems to be the update to each attribute, after it is created: EA.Attribute.update.
Does anyone have any ideas for making this faster?
For scale, I have about 100 classes to create, and about 5-10 attributes for each one, so i'm cool that 500-1000 attributes will take a while, but if there is any way to make it faster, that would be great.

[Geert Bellekens]

I don't think there's much you can do, except for inserting records in the database directly; but that is so naugthy even I don't do that.

Geert

[Ian Mitchell]

Really? Not even once, when you really needed to make it go fast?
Thanks anyway

[ea0522]

Would it be possible to split the action in some smaller actions?
I could imagine there might be a performance penalty in keeping the updates before the final commit.
Which could be tricked with multiple commits in between.

Or maybe using excel for importing?

[Geert Bellekens]

Would it be possible to split the action in some smaller actions?
I could imagine there might be a performance penalty in keeping the updates before the final commit.
Which could be tricked with multiple commits in between.

Or maybe using excel for importing?

t_attribute.Update is the smallest possible operation and it commits immediately.
With excel you would still need the updates, so that doesn't make a difference.

Geert

[Geert Bellekens]

Really? Not even once, when you really needed to make it go fast?
Thanks anyway

No, honestly; never done that

Geert

[Paolo F Cantoni]

I don't think there's much you can do except for inserting records in the database directly, but that is so naughty even I don't do that.

Geert

90% of our repository management is via direct DB manipulation (and has been so for the last decade and more).  If it's naughty, then like Brian, "I'm not the Messiah, just a very naughty boy!"


Once you get over your initial apprehension, it's not that hard.  Qwerty's magic books help a lot!


Paolo

[Modesto Vega]

Hi Ian, are you using a direct database connection or going through PCS? Are you running 32-bit or64-bit?

My experience is that running operations through PCS performs better than direct database connections.