http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11084
--- Comment #37 from David Cook <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
