http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11084 --- Comment #37 from David Cook <dcook@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.