[Bug 13023] Nonpublic note for items should be mapped to a database column like itemnotes
26 Jul
2017
26 Jul
'17
5:02 a.m.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13023 --- Comment #33 from David Cook <dcook@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.
3277
Age (days ago)
3277
Last active (days ago)
0 comments
1 participants
participants (1)
-
bugzilla-daemon@bugs.koha-community.org