[Koha-patches] [PATCH] Bug 4222 - allow nonpublicnote to be a mapped DB column

[Ian Walls]

Galen,


Excellent, yes, removing the dependence on C4::Biblio greatly increases the
speed; not only does it process faster, but it makes it easier to only
select items that something in more_subfields_xml in the first place.  I'm
going to make it part of the script, since my initial tests show that the
wait time for a medium/large catalog is only a few seconds.


-Ian

On Sat, Nov 13, 2010 at 12:39 PM, Galen Charlton <gmcharlt at gmail.com> wrote:

> Hi,
>
> On Sat, Nov 13, 2010 at 12:31 PM, Ian Walls
> <ian.walls at bywatersolutions.com> wrote:
> > Depending on the number of biblios, this could cause the
> updatedatabase.pl
> > script to take a VERY long time to complete.  It would also require the
> use
> > of C4::Biblio (or else rewriting the GetMarcBiblio subroutine within the
> > updatedatabase.pl script).  Is it worth making this part of
> > updatedatabase.pl, or should a separate cleanup script be written?
>
> Actually, it wouldn't require use of C4::Biblio.  If non-public notes
> exist but are not mapped to a field in the items table, they will end
> up in items.more_subfields_xml.  An upgrade script can simply munge
> items.more_subfields_xml and items.nonpublicnote, but would not need
> to touch the bib MARC.  For example, if the note is embedded in the
> 952$x, as far as the bib record is concerned it will remain there;
> only two columns in items would change.
>
> For a database with a large number of item records, it could still
> take a while to complete, so a separate script may still be justified,
> but it wouldn't need to touch the bib records.
>
> Regards,
>
> Galen
> --
> Galen Charlton
> gmcharlt at gmail.com
>



-- 
Ian Walls
Lead Development Specialist
ByWater Solutions
Phone # (888) 900-8944
http://bywatersolutions.com
ian.walls at bywatersolutions.com
Twitter: @sekjal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-patches/attachments/20101113/aaa7802c/attachment.htm>