External Email - Exercise Caution

I'm adding the Library's Picture Collection subject headings 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] with the following commands in the body of the email:

signoff TMSUSERS

// eoj

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