[Koha-bugs] [Bug 13226] Significant slowdown of checkins with fix for notices ignoring the dateformat preference

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13226

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dcook at prosentient.com.au

--- Comment #1 from David Cook <dcook at prosentient.com.au> ---
Very interesting!

I assume that your patrons get "check in" emails? We don't do those kinds of
emails so I never even thought about that happening...

Amazing that it would go from 2.5 seconds to 50 seconds though :S. That's much
much higher than the worst time we recorded for generating overdues.

Olli-Antti Kivilahti processed 12 messages in 31 seconds.
I processed 35 messages in 31 seconds.

Astounding that it would be 1 message in 50 seconds.

I suppose that regex would be running over every single replaceable field. Does
your check in message have a lot of fields to replace with database data?

I'm not sure how to fix this one. The regex idea seemed like the best way of
dealing with the dateformat issue in notices :S.

I thought about using DBIC to check what type of field we were using, but you
can't do that because many table names don't translate to DBIC resultset names.
DBIC is pretty slow too though, so I don't know.

I'm fresh out of ideas on this one :(

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