LISTSERV - TMSUSERS Archives - SI-LISTSERV.SI.EDU

TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

	LISTSERV Archives
	TMSUSERS Home

	Log In
	Register

	Subscribe or Unsubscribe

	Search Archives

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 >>]

Subject:	Re: Manually adding a large thesaurus
From:	Chad Petrovay <[log in to unmask]>
Reply To:	The Museum System (TMS) Users
Date:	Tue, 21 Mar 2023 18:30:34 -0400
Content-Type:	multipart/alternative
Parts/Attachments:	text/plain (2217 bytes) , text/html (4 kB)

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%7Cad1cee1f9a3a41fb563608db2a5bea74%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C638150346487577891%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=a2VWXh3bLJOrP5wwsNAbSFip8bc63XF1nWLsBa%2BEOxc%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

SI-LISTSERV.SI.EDU