[OPEN-ILS-GENERAL] Limits on numbers of attached items?

[Tony Bandy]

Hi all,

I was out of the office yesterday, so I wanted to say thank you very much
for the info...this helps...especially when we are considering serials
and individual library serial records.

Tony

*******************************************
Tony Bandy
tonyb at ohionet.org
OHIONET
1500 West Lane Ave.
Columbus, OH  43221-3975
1-800-686-8975 x19
********************************************



On Tue, Sep 25, 2012 at 5:42 PM, Duimovich, George <
George.Duimovich at nrcan-rncan.gc.ca> wrote:

>
> FWIW,
>
> During the migration of one of our systems to Evergreen, we had about 7-10
> records that hit this limit (out of about 120K records exported from that
> particular branch). All special series titles with thousands of attached
> barcoded items. The ILS exported the MARC records ok, but truncated data in
> our 9xx holdings tags after hitting the 99,999 limit on those records.
>
> George
>
> George Duimovich
> NRCan Library / Bibliothèque de RNCan
>
>
>
>
> -----Original Message-----
> From: open-ils-general-bounces at list.georgialibraries.org [mailto:
> open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Jason
> Stephenson
> Sent: September 25, 2012 13:56
> To: open-ils-general at list.georgialibraries.org
> Subject: Re: [OPEN-ILS-GENERAL] Limits on numbers of attached items?
>
> Quoting Tony Bandy <tonyb at ohionet.org>:
>
> > Hi all,
> >
> > Working with our consortium, specifically related to setting policies,
> etc.
> > does anyone know of the limit of attached items on bibliographic records?
> >  My notes indicate 2,000, but tracking down where that came from is
> > proving elusive....anyone know of the limits?
>
> The only limit that I am aware of is the size of a MARC record is limited
> to 99,999 bytes. If you export a MARC record with holdings in the 852 or
> other tag, depending on the amount of data in the other fields, you can
> quickly run out of room for holdings.
>
> There may be other, system-dependent limitations on how many copies you
> can reasonably attach to a bib, such as the time it takes to retrieve all
> the data and return to the client, the amount of RAM on the client and the
> efficiency or inefficiency of trying to display 2000 copies, etc. These,
> however, will vary depending on the hardware of the servers, the quality of
> the network connection, the hardware on the client, even the client O/S can
> make a difference.
>
>
>
> >
> > Thanks in advance for your thoughts....
> >
> > Tony
> >
> > *******************************************
> > Tony Bandy
> > tonyb at ohionet.org
> > OHIONET
> > 1500 West Lane Ave.
> > Columbus, OH  43221-3975
> > 1-800-686-8975 x19
> > ********************************************
> >
>
>
>
> --
> Jason Stephenson
> Assistant Director for Technology Services Merrimack Valley Library
> Consortium Chief Bug Wrangler, Evergreen ILS
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120927/a7ea2bff/attachment.htm>