Best Jasper prompts for Web Developers

Given a MySQL database with 10 million records, a query that currently takes 5 seconds to execute, and a desired execution time of 500ms, provide a step-by-step plan to optimize the query, including indexing strategies, caching mechanisms, and potential schema changes, assuming the query is a complex JOIN operation involving 5 tables.

Design a secure authentication system using OAuth 2.0 for a web application, assuming a microservices architecture with 5 separate services, each requiring authentication, and provide a detailed description of the authorization flow, including token issuance, validation, and revocation, as well as measures to prevent common attacks such as CSRF and token hijacking.

Analyze a recent 2-hour downtime incident affecting a high-traffic e-commerce website, where the root cause is suspected to be a combination of factors, including a faulty load balancer, inadequate database connections, and insufficient monitoring, and provide a detailed report outlining the likely causes, contributing factors, and recommendations for preventing similar incidents in the future, including changes to infrastructure, code, and monitoring procedures.

Given a 10-year-old legacy codebase with 500,000 lines of code, written in a mix of PHP, JavaScript, and HTML, and characterized by tight coupling, low cohesion, and inadequate testing, provide a step-by-step plan to refactor the codebase, including strategies for dependency injection, module separation, and test-driven development, as well as recommendations for tooling and workflows to support the refactoring process.