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.