Have you considered a front-end query results cache as an additional performance improvement component? Specifically one that automatically invalidates any cache result when the data is modified and doesn't...