TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Blochel-Dittrich, Iris" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Wed, 22 Mar 2023 18:08:49 +0000
Content-Type:
multipart/related
Parts/Attachments:
text/plain (4 kB) , text/html (12 kB) , image001.png (145 kB)
External Email - Exercise Caution
Did you try to refresh everything you can in configuration? (in English it should be something like maintenance / database / recreate full text index etc)


[cid:image001.png@01D95CF1.BB8A7F70]


Dr. Iris Blochel-Dittrich
museum documentation

Stiftung Jüdisches Museum Berlin




Von: The Museum System (TMS) Users <[log in to unmask]> Im Auftrag von David Lowe
Gesendet: Mittwoch, 22. März 2023 18:03
An: [log in to unmask]
Betreff: Re: Manually adding a large thesaurus

External Email - Exercise Caution
Well, deciding to switch platforms is above my paygrade, but thanks. I just need the TMS thesaurus to work faster.

David Lowe | The New York Public Library
Specialist III, Photography Collection


On Tue, Mar 21, 2023 at 7:00 PM Jonathan Benoit <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
I have to disagree Chad. GS uses that as a ‘solution’. Tomcat is better than TMS. Scapegoating there.

If their application constantly leaks memory maybe your ‘solution’ is valid. However, you should then question why they don’t have anything built-in to restart tomcat when a threshold is met.

Code from the 90s? When did they start developing this sloth? Netscape?
It’s impressive that museums keep using it.

I worked at Gallery Systems as a conversion specialist. I’d happily export your data for goodwill if you’d all like to explore your CMS options.

On Tue, Mar 21, 2023 at 6:30 PM Chad Petrovay <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
David, if TMS isn't slow, then the issue is most likely your Tomcat server. Try bouncing the Thesaurus Tomcat server (turning it off and on again).  That might help free up some resources.

On Tue, Mar 21, 2023, 16:38 David Lowe <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
I'm adding the Library's Picture Collection subject headings<https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.nypl.org%2Fabout%2Fdivisions%2Fwallach-division%2Fpicture-collection&data=05%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7Cb1dffb43a8fd49311d9808db2b008105%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C638151053391346541%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=o2%2BxCLjSqWYiE5Lidxe6ld%2FrkY9H6vTjBM%2BsADw%2BfdY%3D&reserved=0> as an internal thesaurus. It has about 12,000 terms. I'm creating this from a "flat" structure (a spreadsheet) into a hierarchical one. I'm pretty proficient with SQL, but haven't figured how to do this programmatically, so I've been chipping away at manually entering the terms. I have about 2,500 to go. Problem is, the Thesaurus has become almost unusably slow. It can take over a minute to ingest one new term (that will be about 42 hours, which I can't spare). The Thesauri bundled with TMS are significantly larger, but run smoothly. Is the problem on our end (ie, the server?), an indexing issue? Something in DB Config (something under Maintenance perhaps)? I've got to speed this up somehow!
Thanks for any help!
d

David Lowe | The New York Public Library
Specialist III, Photography Collection
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.

ATOM RSS1 RSS2