Thanks Dan, The indexes worked perfectly on my test server. I updated the bug notification with the details.
We will be upgrading to the latest stable release of 2.0 at Mohawk College in June to take advantage of all the bug fixes that have taken place. Regards, Robert Robert Soulliere, BA (Hons), MLIS Systems Librarian Mohawk College Library [email protected] Telephone: 905 575 1212 x3936 Fax: 905 575 2011 ________________________________________ From: [email protected] [[email protected]] On Behalf Of Dan Scott [[email protected]] Sent: May 16, 2011 12:16 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] authority records management question On Mon, May 16, 2011 at 10:10:43AM -0400, Soulliere, Robert wrote: > Thanks, Dan, > > I created a bug report as you suggested. I was reluctant to do so since I > was starting with the assumption that it was a local data issue and not a > bug. I was hoping to get a few authority data munging tips I could try before > reporting it as a bug. > > In regards to finding the French records or records with a catalogue language > setting, this query (provided by Mark Bucholtz) worked for us: > > select * from authority.full_rec where tag = '040' and subfield = 'b' and > value = 'fre'; > > I am not sure if this works for every catalogue since it requires the use of > the 040 tag, but it might be another option for some. Thanks Robert. Opening bugs is very often the right thing to do, you might be surprised how often something that you think is a local issue turns out to be a common issue across libraries. I responded to the bug (https://bugs.launchpad.net/evergreen/+bug/783486 for the curious) with the suggestion of creating two indexes that, on our test server with 1.1 million authority records and 16 GB of RAM, cuts query execution time for the standard "right-click on a field in the MARC editor" down from 5500 ms to 0.23 ms. Assuming that the same indexes help your case, I'll ensure that they get added into the upgrade script for 2.0.7. So, you shouldn't have to prune your set of authority records at all; a little bit of database tuning, in this case, goes a very long way. Dan This E-mail contains privileged and confidential information intended only for the individual or entity named in the message. If the reader of this message is not the intended recipient, or the agent responsible to deliver it to the intended recipient, you are hereby notified that any review, dissemination, distribution or copying of this communication is prohibited. If this communication was received in error, please notify the sender by reply E-mail immediately, and delete and destroy the original message.
