Best ChatGPT prompts for Computer Programmers

Given a PostgreSQL database with 100 million records, a query that joins three tables and performs aggregation on the results, and an average query execution time of 10 seconds, suggest a step-by-step plan to optimize the query performance, including indexing strategies, query rewriting, and statistics analysis, and provide the expected performance gain after each optimization step, assuming the database server has 16 GB of RAM and 8 CPU cores.

Analyze a microservices-based e-commerce application with 10 services, each written in a different programming language, and identify the potential root causes of a recent outage that resulted in a 30% drop in sales, considering factors such as service dependencies, network latency, and resource utilization, and provide a prioritized list of recommendations to prevent similar outages in the future, along with a step-by-step plan to implement each recommendation, assuming the application is deployed on a Kubernetes cluster with 20 nodes.

Design a real-time data processing pipeline using Apache Kafka, Apache Storm, and Apache Cassandra to process 100,000 events per second from IoT devices, with a requirement to perform data aggregation, filtering, and alerts generation within a 1-second latency window, and provide a detailed architecture diagram, along with a step-by-step plan to implement and deploy the pipeline, assuming the pipeline will be deployed on a cloud-based infrastructure with 10 nodes.

Perform a code review of a 10-year-old Java-based legacy codebase with 1 million lines of code, and identify areas of improvement, including performance bottlenecks, security vulnerabilities, and code smells, and provide a step-by-step plan to refactor the codebase, including suggestions for code reorganization, dependency injection, and testing strategies, and estimate the expected reduction in technical debt and improvement in code maintainability after refactoring, assuming the codebase has 1000 dependencies and 5000 unit tests.