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
117 Sandusky Street
Pittsburgh, PA 15212
T 412.237.8306
F 412.237.8340
E [log in to unmask]
W www.warhol.org <http://www.warhol.org/>  

 

 

________________________________

From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Rebecca Ronsaville
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 Paul Getty Museum

[log in to unmask]

310-440-6075