# Search Before a Search Engine

Page: https://stenobird.com/podcast/programming-tech-brief-by-hackernoon-6364125/search-before-a-search-engine
Text version: https://stenobird.com/podcast/programming-tech-brief-by-hackernoon-6364125/search-before-a-search-engine.md
Podcast: [Programming Tech Brief By HackerNoon](https://stenobird.com/podcast/programming-tech-brief-by-hackernoon-6364125)
Published: 2026-06-20T16:00:40+00:00
Episode link: https://share.transistor.fm/s/d8665433
Audio file: https://media.transistor.fm/d8665433/77a2f04f.mp3
Processing state: not_requested
JSON: https://stenobird.com/v1/public/podcasts/programming-tech-brief-by-hackernoon-6364125/episodes/search-before-a-search-engine
Duration seconds: 935

## Resource

This story was originally published on HackerNoon at: https://hackernoon.com/search-before-a-search-engine . Why a search feature slows down in MySQL, and how to fix it without a search engine: single round-trip paging, index hints, full-text, and parallel queries. Check more stories related to programming at: https://hackernoon.com/c/programming . You can also check exclusive content about #elasticsearch , #.net , #mysql , #ef-core , #database-optimization , #entity-framework-core , #sql-optimization , #hackernoon-top-story , and more. This story was written by: @fedoryshchev . Learn more about this writer by checking @fedoryshchev's about page, and for more stories, please visit hackernoon.com . A search feature gets slow not because you lack a search engine, but because the access pattern outgrew the data model. To fix it before buying new infrastructure, you climb a ladder of cheaper, reversible changes: single round-trip paging, index hints, full-text and suffix indexing, and parallel queries, weighing each option's price along the way.

## Actions

- request_transcript: `POST https://stenobird.com/v1/public/podcasts/programming-tech-brief-by-hackernoon-6364125/episodes/search-before-a-search-engine/transcription-requests` — Idempotently request low-priority transcript generation for this episode.
- read_markdown: `GET https://stenobird.com/podcast/programming-tech-brief-by-hackernoon-6364125/search-before-a-search-engine.md` — Read the agent-friendly Markdown representation of this episode resource.

A page view does not enqueue transcription. Agents should invoke `request_transcript` explicitly when they need this episode processed.

## Transcript

Full transcripts are not published on public pages unless there is a clear rights basis.