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 <[email protected]> wrote: > Hi, > > On Sat, Nov 13, 2010 at 12:31 PM, Ian Walls > <[email protected]> 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 > [email protected] > -- Ian Walls Lead Development Specialist ByWater Solutions Phone # (888) 900-8944 http://bywatersolutions.com [email protected] Twitter: @sekjal
_______________________________________________ Koha-patches mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
