[Koha-bugs] [Bug 11084] Delete biblios on Leader 05 =d
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Jan 11 02:02:08 CET 2016
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11084
--- Comment #37 from David Cook <dcook at prosentient.com.au> ---
Comment on attachment 46021
--> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=46021
Bug 11084 - Delete biblios on Leader 05 == d
Review of attachment 46021:
--> (http://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=11084&attachment=46021)
-----------------------------------------------------------------
::: misc/cronjobs/delete_records_via_leader.pl
@@ +67,5 @@
> +}
> +
> +my $schema = Koha::Database->new()->schema();
> +my @biblioitems =
> + $schema->resultset('Biblioitem')->search( { marc => { LIKE => '_____d%' } } );
We're reading the 'marc' field as a string?
While that's pretty fast on smaller databases, it takes about 60 seconds on a
database with about 1.1 million bib records. I suppose performance doesn't
matter too much for a cronjob though - depending on the frequency that it's
run.
Also, aren't we trying to get rid of the biblioitems.marc field? See:
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10455
Wouldn't it be better if we started indexing LDR05 as 'rstatus' or
"record_status' or some such?
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list