How exactly did you optimize database operations and implement selective Redis caching to reduce complex report generation from 15 to 1.5 seconds?