[Koha-bugs] [Bug 20819] GDPR: Add a consent field for processing personal data in account menu and self-registration

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

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

--- Comment #67 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to Jonathan Druart from comment #66)
> +        my $consent = Koha::Patron::Consents->search({
> +            borrowernumber => getborrowernumber($user),
> +            type => 'GDPR_PROCESSING',
> +            given_on => { '!=', undef },
> +        })->next;
> +        if( !$consent ) {
> 
> 
> ->count could have been better.

I tested that assumption a bit. And it seems not to be true in terms of
performance at least?
In short:
1.3480 sec for 1000 counts and 0.0094 for 1000 next's (on 1000 records).
It seems that DBIx goes to the db for each count but the repeated nexts are
handled much more efficiently (cache, prefetch, ..)?

Script fragment on next comment.

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