Skip to content

Results for “indexes”

2 prompts

Act as a performance engineer. Language: [language] What the code does: [description] Typical input size: [e.g. 1M rows, 10k requests/min] Current speed/problem: [e.g. takes 40 seconds, high memory] Please: 1. Identify the bottlenecks and explain the current time and space complexity 2. Propose optimisations (better a…

ChatGPT
Coding & Development

Optimise slow code for performance

Find the bottlenecks in slow code, understand the time complexity, and get a faster version with benchmarks to prove it.

0

Act as a SQL expert. Database: [MySQL / PostgreSQL / SQLite / SQL Server] Tables: [table_name](column1 type, column2 type, ...) [table_name](...) What I want: [describe the result in plain English, e.g. "top 10 customers by total spend in 2025, with their order count"] Please: 1. Write the query with clear aliases and…

ChatGPT
Coding & Development

SQL query from plain English

Describe the data you need in normal words and get a correct, readable SQL query with an explanation and performance tips.

0