menu

Recent posts tagged query-optimization

Level UI • 21 hours • in Articles • 9 min read
An MCP server is not a new API. It is a thin layer over the one you already have
Somewhere in the last year, "do we need an MCP server?" joined the list of questions that arrive in a brief before anyone has said what the thing is for. It is usually framed as MCP vs API, as though the Model Context Protocol were a newer kind of AP...
post-cover-33074
  • ai
  • api
  • webdev
  • security
7 Reactions 7 Comments
rozhnev • Jun 22 • in Articles • 3 min read
INNER JOIN vs Correlated Subquery in SQL: What Is Actually Faster?
Most SQL developers hear the same rule early: always prefer INNER JOIN over correlated subqueries, because subqueries create an N+1 performance problem. That rule is useful, but it is not always true. I tested this on four engines MySQL, Oracle, P...
post-cover-21160
  • sql
  • inner-join
  • query-optimization
  • database-performance
7 Reactions 1 Comments
Derrick Ryan • Feb 16 • in Articles • 7 min read
Oracle AI Vector Search: Querying Vectors and Optimizing with Indexes
Oracle Database 23ai's AI Vector Search enables powerful semantic search capabilities, but to truly harness its potential, you need to understand how to query vector data efficiently and when to use vector indexes. This guide explores querying vector...
  • oracle-database-23ai
  • vector-search
  • hnsw-ivf
  • query-optimization
2 Reactions 1 Comments
liangk • Feb 11 • in Articles • 12 min read
We Measured the N+1 Query Problem. The Numbers Are Worse Than You Think.
I kept seeing the same advice in every ORM tutorial: "Watch out for N+1 queries." Every code review, every blog post, every conference talk. Always the same warning, never the actual numbers. So I decided to measure it. I built a benchmark suite, ...
post-cover-11471
  • n-plus-1
  • performance
  • benchmarking
  • query-optimization
6 Reactions 1 Comments
To see more, click for the full list of posts or popular tags.
chevron_left
🔥 3 posts • 👩‍💻 3 active writers
✨ Want to write in this topic?
Share your learning. Get discovered. Build your profile.
Join CoderLegion
💡 Why developers use CoderLegion
Track learning • Share posts • Get ranked publicly
Create your profile