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:
April Brown <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Wed, 22 Mar 2023 18:27:21 +0000
Content-Type:
multipart/alternative
Parts/Attachments:
text/plain (3761 bytes) , text/html (8 kB)
External Email - Exercise Caution
I did a similar thing although not with nearly as many terms. I actually got my Intern to do it. He got up to about 750 terms – off of one root term (I didn’t want a hierarchical listing)- and it wouldn’t let us add any more terms. TMS’s solution was to restart the Thesaurus Tomcat. That didn’t work. So now I’m adding the terms under alphabetical root terms (A,B,C…) but it still won’t let me add “new” terms to the list which is quite frustrating. I also get a lot of those blue swirls when the thesaurus is loading – even though I have far fewer terms under one root term than previously. I’m still not done reworking it.

If you find a solution to your issue it might help with mine.

April Brown
Registrar
The Charles Hosmer Morse Museum of American Art
445 N. Park Ave. | Winter Park, FL 32789
https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.morsemuseum.org%2F&data=05%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C3f44840355e8430701c808db2b0315fe%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C638151064491968900%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=kmcQzCnhpnRUvCVqEXk%2B%2FGT%2FuvrTCgN6LvtbXJ70iXY%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.morsemuseum.org%2F&data=05%7C01%7CTMSUSERS%40SI-LISTSERV.SI.EDU%7C3f44840355e8430701c808db2b0315fe%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C638151064491968900%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=kmcQzCnhpnRUvCVqEXk%2B%2FGT%2FuvrTCgN6LvtbXJ70iXY%3D&reserved=0>



From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of David Lowe
Sent: Tuesday, March 21, 2023 4:38 PM
To: [log in to unmask]
Subject: Manually adding a large thesaurus

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%7C3f44840355e8430701c808db2b0315fe%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C638151064491968900%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=L54spYeOULcTCB8Cx21JivVm6%2BoMx2yjumhq8tFwNtY%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] 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