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

--- Comment #27 from Tomás Cohen Arazi (tcohen) <[email protected]> ---
(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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://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/

Reply via email to