I’ll
let you know in a few days… we should be starting the DMU on our test DB
in a day or two. So we’re right around the same place you are.
the warhol:
Amber E. Morgan
Associate Registrar
T 412.237.8306
F 412.237.8340
E [log in to unmask]
W www.warhol.org
From:
Sent: Monday, August 09, 2010 1:39
PM
To: [log in to unmask]
Subject: TMS 2010 : Upgrade DMU
Slowness
Hello -
Has anyone
encountered speed issues running the DMU for TMS 2010?
We have run through
the entire upgrade process twice so far on our test database, and some of the
tasks are taking a very long time. Specifically the following two DMU
tasks are taking the longest:
Populate Object
Attribution Field = 43 hours
Merge Loan-Related
Roles = 23 hrs
End to end, the
entire upgrade process (scripts, updateDD, DMU, etc) is taking ~75
hours. I understand that the DMU will respond differently given your
dataset, but our record set is relatively small. The Object Attribution
process looks to be inserting 300k records into the ConXrefSets table,
which isn't that many, but each one sets off 3 triggers, so that adds to the
overhead. Still, it shouldn't be taking that long.
We are on Oracle
10.2.0.4.
Please let me know
if you have had similar experiences and especially if you have any suggestions
on how I can combat it.
Thanks,
Rebecca
Rebecca Ronsaville
Software Engineer
J
310-440-6075