>The problem is, when you update a record, all indices are updated as well. It doesn't seem easy to design the product in a way that would somehow bypass this.

Not necessarily to bypass it but to enhance in that direction. I'm sure this could be enhance and I'd look forward to it. I'll add a wish for that.