[OPEN-ILS-GENERAL] authority records management question

[Soulliere, Robert]

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
robert.soulliere at mohawkcollege.ca
Telephone: 905 575 1212 x3936
Fax: 905 575 2011
________________________________________
From: open-ils-general-bounces at list.georgialibraries.org [open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Dan Scott [dan at coffeecode.net]
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.