[Koha-bugs] [Bug 13023] Nonpublic note for items should be mapped to a database column like itemnotes

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13023

--- Comment #33 from David Cook <dcook at prosentient.com.au> ---
(In reply to David Cook from comment #32)
> (In reply to Katrin Fischer from comment #30)
> > David, take a look at: misc/batchRebuildItemsTables.pl -c
> > But beware, it's slow.
> 
> I only had a few thousand records to touch in a database with over a million
> records, so I gave it one of these and it completed pretty quickly:
> 
> perl batchRebuildItemsTables.pl -c --where="biblio.biblionumber in (select
> biblionumber from items where more_subfields_xml is not null group by
> biblionumber)"

That is, it took about 75 seconds to do 2354 records.

-- 
You are receiving this mail because:
You are watching all bug changes.