https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42508 --- Comment #27 from Tomás Cohen Arazi (tcohen) <tomascohen@gmail.com> --- (In reply to David Cook from comment #26)
Doing a quick scan of the comments... I think the issue is the extended patron attributes because they are stored in a normalized format in the database.
Yeah sometimes denormalising is the right answer for performance. I've done that in the past using DB triggers, but another option is using an ORM software trigger. I mean we already override store() methods, so that's trivial.
Look at the code I provided and the things I index. All the software triggers we need are implemented in it. I’ll take a look at making an SQL driver using a denormalized table this week. As I said, there are tradeoffs here, but the design allows adding a DB backend easily. There’s a lot of analysis and the code i submitted is the result of many iterations. Please look at it. -- You are receiving this mail because: You are watching all bug changes.