Re:Good Advice on Keeping Your Database Simple and Fast
by jws on Thursday March 26, 2009 @09:18AM
(#533400)
Transactional integrity becomes trickier when you blnd two storage systems.
The orthogonal idea of keeping a premarkedup version has worked well for me as an optimization. I use triggers to delete the marked up copy when any of its inputs change. The access function recreates it if needed.
The orthogonal idea of keeping a premarkedup version has worked well for me as an optimization. I use triggers to delete the marked up copy when any of its inputs change. The access function recreates it if needed.