Your app is not slow: it runs 300 queries
The screen takes four seconds and the server is not under load. It is almost always the same problem, it has a name, and it is fixed by changing one line. How to spot it without special tools.
· 4 min
3 articles
The screen takes four seconds and the server is not under load. It is almost always the same problem, it has a name, and it is fixed by changing one line. How to spot it without special tools.
Job queue, full-text search, cache, events and semantic search. Four services people tend to add to the stack that the database you already have can handle, with the exact SQL for each one.
In almost every language, incorrect code breaks and tells you. An incorrect SQL query runs, returns rows and nobody finds out. What to check before accepting one, and what changed in the databases themselves.