PMA has almost 18,000 locations, but so far I've had no slowness in
searching them in our test version of TMS 2010.

--Jessica


__________________________________
Jessica Milby 
Collections Information Project Manager 
Philadelphia Museum of Art 
Phone: 215-684-7283 
Fax: 215-235-0035 
[log in to unmask]


-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]
On Behalf Of Heikki Pauts
Sent: Wednesday, August 11, 2010 2:43 AM
To: [log in to unmask]
Subject: Re: TMS 2010 : Upgrade DMU Slowness

Hi there,

I am happy to report, that our DMU (SQL Server 2005) took in total 4
hours 
and 30 minutes, without any errors.
But on the other hand, this new link between Home Constituents and 
Locations has had a negative effect on the speed of searching in
Locations - 
we sometimes have to wait almost a minute before we can move from Site
to 
Room. I try to explain it with the large amount of our Locations - more
than 
17.000 divided between 4 Home Locations (anybody else having this 
number?), but I am not sure if this is the only reason.
I hope 2010 R2 will address this issue!

Greetings,
Heikki Pauts

-----------------------------------------------
Mr. Heikki Pauts
registrar
TMS2010
National Museum of Antiquities
Leiden, The Netherlands
http://www.rmo.nl
http://nl.linkedin.com/in/heikkipauts


On Tue, 10 Aug 2010 09:12:15 -0400, Kate Blanch 
<[log in to unmask]> wrote:

>Hi all, we too experienced time-out issues/DMU crashing/running beyond
>24 hours and being unresponsive during the "Home Constituent/Locations"
>set of tasks. We are still testing in our test environment so didn't
>really suffer any loss...we just received a new DMU from Brian and
>Dimitry and hopefully it will be resolved. Our record set is not huge,
>so we were puzzled to have this kind of issue. It's great to receive
>feedback from others! Keep me posted!
>
>Kate Blanch
>Administrator, Museum Databases
>
>[log in to unmask] <mailto:[log in to unmask]>  / 410.547.9000
>ext. 266 
>The Walters Art Museum
>600 N. Charles Street, Baltimore MD 21201
>www.thewalters.org <http://www.thewalters.org/